How do I separate out items in a report from a configurable list?

  • Profile Image
    Asked on October 07, 2016 at 01:29 AM

    I'm trying to make an order form that does not need a payment feature (internal order of our own supplies by our managers to our supplies dept). I have sections with different types of supplies (i.e., tables and chairs, electrical, safety & security etc). Each section is a configured list with a drop down of different items to choose from, and then a field to add a quantity for each item selected. 

    When I export a report to excel, I get all the items chosen for each section in one column. Is there a way to export each item and quantity to a separate column?

  • Profile Image
    Answered on October 07, 2016 at 02:24 AM

    Unfortunately it is not possible to automatically export each item in the configurable list into separate columns. Widgets are considered as one field, so no matter how many sub-fields they may have, all data that is collected through that widget will be stored in only one cell/column on Excel.

    If you want to split the data into multiple columns, you will have to manually split them using the Convert Text to Column feature of Excel. You can do this by following their guide here: Split text into different columns with the Convert Text to Columns Wizard.

    Please let us know if you need further assistance.