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

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



    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



  • Profile Image
    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.