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

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

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.