Hello!
I have this problem, I have several multi-select questions in one of my surveys and I have Excel integrated, so I can start receiving the data.
The problem is the multi select data is all packed in the same cell, just separated by comas. If I want to start to create my formulas and some charts I would need to get rid of the comas and I will touch the raw data. Something I don’t want to do.
Is there any way to have this fixed so the multi-select data appears by columns and not all in one cell?
Current example:
Which fruits do you usually consume? |
Apple, Orange, Strawberry, Melon |
Orange, Melon |
What I would like to have:
Which fruits do you usually consume? | |||
Apple | Orange | Melon | Strawberry |
1 | 1 | 1 | 1 |
0 | 1 | 1 | 0 |