How to separate each product in the product list column on Google Sheets?

Hello,

Is there anyway way for the form results to have each separate product and which stores ordered it by column? We don't the sizes to be spaced out, but maybe just the different products as separate columns and then the size run in the row underneath (which would also indicate the store)

Hi Gabriella,

Thanks for reaching out to Jotform Support. Can you explain a bit more about your request, so I can get a better idea of it? Also, can you send us the link to your form for us to investigate it further?

Once we hear back from you, we'll be able to help you with this.

https://form.jotform.com/242255915849164

Here is the form

And here is the excel again. I made one tab the way Jotform does it and the second tab is what we wanted the results to look like automatically (and not manually)

Thanks!

Hi Gabriella,

I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

Hi Gabriella,

Although we don't have an option to automatically separate the products in the product list field in Google Sheets, as a workaround, you can manually separate the products in your product list field in Google Sheets using the Split Data feature. I cloned your form and applied the changes on the Google Sheets. Check out the screenshot below:

As you can see, the products in the product list widget have their own column in Google Sheets. Let me show you how to do it:

1. In Google Sheets, click on the column header of your product list field.

2. Click on Data at the top part of the screen.
3. Click on Split Text to Columns.

4. In the Separator dropdown, select Custom.

5. Enter close parenthesis in the Separator field.

That's it. Let us know if you have any other questions.