Product List: Option to split the data into different fields

I have multiple products on my form using Stripe for payments. When I output the form data using Google Sheets or using the report function, every product and price ends up in one field (see attached png). I need to be able to have each product chosen reported in a different field, with the amount in a separate field so I can total the sales separately for each product.

Hi Tim,

Thanks for reaching out to Jotform Support. Since the Product List is considered one field, its data is put in one cell. Unfortunately, there's no option to put the data into separate columns. The workaround is to utilize the split-to-column feature for Excel. You can follow the steps in this guide to do that.

While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. 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. 

Thanks for your patience and understanding, we appreciate it.