How can I organize information from a multiple choice box?

  • Profile Image
    gomezjasmine
    Asked on April 11, 2017 at 10:28 AM

    I have created a form and the user is able to select more than one option. When I download the submissions, I get all of their answers in the same column. Is there a way to organize it so that each response goes to its own excel column. 

  • Profile Image
    Welvin
    Answered on April 11, 2017 at 12:44 PM

    I'm sorry, but that's how we place the selected options in the Excel or CSV file of the submissions. If you need to separate the options into a difference cell, you would need to do it manually. You can do it with Text to Column function in Excel.

    https://www.extendoffice.com/documents/excel/1786-excel-split-text-by-space.html