Is there a way to have each item on the purchase order show up as it's own column in an excel report?

https://form.jotform.com/73174458086161

I am trying to figure out how I can get each item from this purchase report to show up in a report so I can see the quantity sold of each item. Is there a way to do this?

Thank you for contacting us. 

If you want to see your products in different columns on submission page, it is currently not possible with your current settings. This is because, as you add your product details inside the payment integration, all your payment details will show in one column since the payment integration is assumed as a single field. 

On the other hand, you may want to have a look at the following user guide:

https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

This guide states that you can set your products with some basic fields such as Dropdown, Multiple Choice, Single Choice or with some widgets such as "Inventory" and calculate the total price with "Form Calculation" widget. Then, you can pass the calculated value to the payment integration. With this way, you will be able to see product details in different columns.

If you want to split product informations to different columns on excel file, you can use excel's own feature. The following guide can help you about this:

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

If you have more questions, please feel free to contact us.