Is it possible to export products into different excel colums/cells?

Hi, when I download my data into excel, all of the products are exported into one cell. Ie, each registrant can select one or mult of the following--- Registration, Workshop, Meal ticket, Membership---all which have different costs (and can be at Regular or Student rates.) Therefore, for me to track total costs, I have to manually enter all of this data into a separate excel file, creating a column for each option (Regular Registration, Student Registration, Regular Workshop, Student Workshop, etc etc.)

A large part of the reason we attempted online registration is so I could avoid having to manually enter the data into an excel file. This current format actually creates MORE work for me than if I were to get a paper registration form and have to enter it manually.

Does jotform have any options/ solutions for this issue?

I attached a link to our 2016 registration form. I need to create a new form for our 2017 conference, and would like to figure out if this is possible ASAP, because I am hoping to have the registration form available to our members before Christmas.

Thank you very much for your time.

Virginia Tilden

Treasurer, PA Chapter of The Wildlife Society

Unfortunately, there is no configuration in the form builder to split the selected products item into separate columns in the excel or google spreadsheet files. A workaround would be the following:

1. Using text to columns function in Excel: https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-US&rs=en-US&ad=US.

2. By installing this addon for excel: https://www.extendoffice.com/documents/excel/1786-excel-split-text-by-space.html#kutools-split-cells. 

Please try it and get back to us if you need further assistance.