How to have options go in separate columns on the spread sheet?

I need help . I am trying to set up options that go into separate columns on the spreadsheet. I tried to use the spread to columns feature, but it still all goes into the same column. Is there a way to make this happen? Also is there a way to have a option to say you will volunteer to bring a table and have a place to say how many you are bringing?

Hi Cindy,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

To have options go into separate columns on your spreadsheet, you can use the Expand column feature in Jotform Tables. Click the three-dot menu on the column you want to adjust, then select Expand column to separate subfields into different columns.

For your volunteer option, you can add a question like "Will you bring a table?" with a checkbox or dropdown, and then add a separate field to specify the number of tables or people you are bringing.

Give it a try and let us know how it goes.

I tried that but it still all goes in the same column

Hi Cindy,

If the options still appear in the same column after using the Expand column feature, please make sure you are applying it to the correct column in Jotform Tables. Sometimes, combined fields like multiple-choice options need to be expanded individually.

Also, check if the spreadsheet or export settings might be merging the data back into one column. You can try exporting the data again or adjusting the column visibility and organization in Jotform Tables.

i checked i used the correct part of the form but still not working

Hi Cindy,

If expanding the column still doesn't work, try checking your export settings or re-export the data to see if the columns separate correctly. Also, ensure no spreadsheet software settings are merging columns after export.

In Jotform Tables, you can also manage columns by showing, hiding, or rearranging them using the Columns button or tab menu to better organize your data.

Can I talk to a human

Hi Cindy,

One of our Support Team members will take it from here to follow up shortly.

thank you

Hi cindecator,

I understand how important it is for you to have the data separated columns. Unfortunately, there's no option to split the data into columns or rows at the moment. However, you can do that after downloading the submission to an Excel spreadsheet. Here are a few workarounds suggested by my colleagues.

• How to separate data into separate Excel columns
• Using normal fields and widgets

Let us know if there’s anything else we can help you with.