Checkbox Field: On Excel Report, show each check option in a separate column

  • Profile Image
    GuyPalinckxLS
    Asked on September 26, 2016 at 07:32 AM

    Hi,

     

    When I use a question with a checkbox (multiple answers are possible) I found the data in excel in 1 cell.

    e.g.  when I have an option "Monday", "Tuesday", "Wednesday", "Thursday", "Friday" and I choose for Monday and Thursday, in my report, it' says MondayThursday in 1 cell.

    Sometimes I need to filter this but like this, it's very hard.

     

    Is there another solution for separation of data?

     

    Thanks in advance

     

    Guy

  • Profile Image
    kate
    Answered on September 26, 2016 at 09:41 AM

    To create a separation of data, first,  create a different checkbox field for each option, as you see below:

     

    Here is the result:

     

    Please give this a try and if you have any questions please let me know.