Product list: split content across separate columns

Hi I created a form for camp lunch selections for parents to fill out. Currently the form populates all the meal requests in one column which makes it really difficult to plan out each day. I would like to have the results where each day of the week's selection is in a different column. Is there are way to do this? You can see in the screen shot the column "Meal Choices" has all of the meals selected for each day of the week in one column - How do I break this up with Monday in one column, Tuesday in another, etc.

I also don't need to see the prices as lunch is included in the cost of camp - is there a way to remove the dollar value all together? This isn't the biggest deal but it would be helpful.

Also how can I make it so parents can only select ONE meal per day?

Thanks so much

Hi langford0916,

Thanks for reaching out to Jotform Support. Sorry, but splitting the product list data across separate columns on the submission table and also the downloaded Excel is currently not supported. I've gone ahead and escalated your request to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll follow up on this thread and let you know.

Since you've downloaded the data in Excel, you can use the Excel's Text to Column feature to separate the Product List's data into separate columns. You can also check out this guide about Split text into different columns with the Convert Text to Columns Wizard.

Thanks for your patience and understanding, we appreciate it.