What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How do I separate out items in a report from a configurable list?Asked by karen.mcbride 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?
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.