How can I export items in a purchase order field as separate fields?

  • Profile Image
    Asked on November 17, 2011 at 05:56 PM

    In excel, they are all grouped as one long string of things, instead of in separate rows or columns.  Is there a way to get around this?  I would use regular fields, but I need for the items to total a dollar amount at the end based on how many they select.

    Excel can't separate the cell into columns because of the way it's formatted.


    Thanks for any help with this!

  • Profile Image
    Answered on November 18, 2011 at 03:00 AM

    Unfortunately, there is no way to get the purchase order/payment details split into mutliple columns on the Excel report, since the data is irregular.