Separate products in spreadsheet

I've just seen my submissions table now in GSheets https://www.jotform.com/tables/202191619019553

If I could just separate the items in Column F I would be very very happy. There has got to be a way?

Unfortunately, we do not currently have a setting to separate the products into different cells on Excel but there's a workaround for that. You can check it on this thread https://www.jotform.com/answers/409905.

Thanks for this but that means I have to do this each time I download the excel. Did I use the wrong element in the first place and if so which element would allow for an export that would show each item ordered in a seperate cell?

That requires ditching the payment/order field entirely, then adding normal form fields and widgets such as drop-down, Inventory Widget, text input, etc.

Then use the Calculation widget to calculate total price of all products selected within fields. Total Price can then be passed to Payment Integration.

Related guide: How-to-Pass-a-Calculation-to-a-Payment-Field

I hope I have been of any help.