PDF Reports: Reporting each product sold in a seprate excel column

We have three products for sale. All three are reported in the export in a single column with no delimiter character. There is no way to use the text to column function in excel to create a pivot table to show the total quantities of each item sold.

Unfortunately, this is not possible to separate each product in a separate cell. You may follow the following workaround:

1. You may view the reports in a Grid view. Refer this guide:

https://www.jotform.com/help/105-How-to-Create-a-Grid-Listing-Report

2. You may also separate the fields for each product selected, its quantity, and its size on your excel report, I would like to suggest you try to recreate the whole order field into separate fields using the regular form tools(drop-down fields, checkboxes, and textboxes). Computations can be done through conditions and style of the form can be done with the help of injected custom CSS codes to your form

It's possible by following the guides below.

1. First, you will need to recreate the products using the plain form fields.

2. You can then position those fields, let's say you want to put the quantity dropdown and the sizes dropdown on the same line, you can do that by following this guide:

http://www.jotform.com/help/328-How-to-Position-Fields-in-JotForm.

3. After that, you can assign calculation values on your drop down fields (quantity and sizes) that will be used in calculating your total.

Here's a guide to follow: http://www.jotform.com/help/301-How-to-Assign-Calculation-Value 

4. The next step would be to used the Form Calculation widget to get the total of the orders. To learn more on how to use the form calculation widget.

Here's a link that you can visit: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form 

5. Now the question is, how to pass the calculated total to your payment integration? That's possible by using the custom donation/total option in your payment wizard.

Here's a guide on how to do that: http://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field.

Hope this information helps.

Thanks.