How to extract some field of product in Products in excel generated by Jotform?

Hi

Please check the attached image.

There are four products. I need to separate each product from products. Then it will be separated into four products and one more line that shows total field.

From each product, I need to get some number. The numbers I need to extract are in the attached photo.

I don't know why Jotform produces all the product attributes in one cell. This should be reflected in the design stage.

Best regards

Hi gominesales,

Thanks for reaching out to Jotform Support. Unfortunately, It's not currently possible to split the values/items selected on the Product List element when exported to MS Excel; in the meantime, you'll have to manually split them from within the Excel spreadsheet. I've gone ahead and escalated your request to our Developer Team. When or if it's developed depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know. You can also try the following:

• Use JotPayments
• Customize a Visual Report
• Create a Grid Listing Report

Thanks for your patience and understanding, we appreciate it.