Multiple Options / Sorting Data

I have a field with multiple options available to the registrants. In the excel sheet or table, those options all end up in the same column/field and I can't sort to identify each one registered for the alternative dates. What is the proper way to set up that question?

Hello,

Since this is a multiple-choice field all options are part of that single question. So it behaves in a similar way on excel too.

On excel, each question appears in separate columns. Hence the options selected by default appear in a single cell in excel too.

You will need to manually split them to separate cells after you download the excel submission document.

Please check this workaround suggested by my colleague on this ticket link: https://www.jotform.com/answers/2400554-split-muliple-choice-fields-into-separate-columns-in-excel

I never knew about the "Split Text to Columns" function in Excel/Sheets.

That works!