Multiple Options / Sorting Data

  • Profile Image
    Antoinette_Follett
    Asked on February 18, 2021 at 06:57 PM

    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?

    1613692561_602efe9191005_Screen Shot 202

  • Profile Image
    gerardw
    Answered on February 18, 2021 at 11:41 PM

    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

  • Profile Image
    Antoinette_Follett
    Answered on February 19, 2021 at 09:40 AM

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

    That works!