I use Purcahse Order (product selection) widget and need consolidated report

I am using a Purchase Order widget on the form, and when I get the Excel report see all the products grouped in one column.

I need to know how many of each product was ordered from all submissions.

How do I do that?

This is how the Purchase Order payment field work.  The items/products in the payment field will always be considered as single element only.

So the output report or spreadsheet will always contain the data in a single column only since it is reading the data on single field only.

If you want the items/products on your Purchase Order Form results/output to be individually configured in the output report, then, you will need to use custom Purchase Order.

You can do this using individual fields for each of the items/products you want to use on the form.

Example: https://form.jotform.com/62697911369975

Hope this help. Let us know if you need further assistance.