How can I separate multiple choice responses into separate columns in Excel?

  • Profile Image
    Asked on August 22, 2017 at 04:50 PM

    I have a form where the user is asked to make one or more selections from a checkbox question. Is there a way to have the options populate separate columns in a submission report? Alternatively, I could use a dropdown menu, but I don't want the user's selections to be lumped into one column.

  • Profile Image
    Answered on August 22, 2017 at 05:12 PM

    Its possible. But you would have to use one multiple choice field per question.