- GuyPalinckxLSAsked 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
- kateAnswered 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.