How to separate products and prices in separate cells in the reports?

I want to be able to generate reports based on items purchased through jot form. People have bought books, t-shirts, tickets and more but when I want to get totals for a specific item, I can't. The self generated spreadsheet lumps all of the purchased items in one column, which defeats the purpose of this spreadsheet.

You may check the Grid report:

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

To see the total of each product separately, you can configure the products outside of the payment field using the traditional elements like dropdown for quantity, Image element if you want to show the picture of the product, text box, multiple choice to select the sub-products. Then pass the total amount to the payment field.

Please check this guide:

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

Let us know if you have further questions.

Thanks.