-
wfecrebatesAsked on May 7, 2018 at 4:31 PM
-
Mike_G JotForm SupportReplied on May 7, 2018 at 6:01 PM
I'm afraid there is no option within the form for you to be able to do that. However, you can do the workaround below to the Excel file of your submission to separate products into columns.
First, you need to anticipate the maximum number of lines the payment field in your form creates in the Excel file.
I just assumed you are referring to the 2018 Emerging Technology Conference form in your account, is that correct?
I created a clone version of that form and made a test submission with all the products in the payment field selected.
In the Excel File, the payment field has a total of 5 lines.
Since that is the case, you need to insert 4 columns after the payment field in the Excel file.
After that, select the entire Payment field column in the Excel File and click the "Text to Columns" option under the DATA tab.
Then, on the Convert Text to Columns Wizard, select "Delimited" and click Next.
On the next page, deselect all the Delimiters except for "Other". Put your mouse cursor on the "Other" box and press CTRL+J on your keyboard. Then, click Next.
On the last page, you don't have to change anything and just click Finish.
Here's the result:
Here's also a reference that you can use — https://www.howtoexcel.org/tips-and-tricks/how-to-separate-data-in-a-cell-based-on-line-breaks/
I hope this helps. If you have other questions or concerns, please feel free to let us know.