I have a table like this one here (basically it's data from a google form with multiple choice answers in column A and B and non-muliple choice data in column C) I need a separate row for each multiple choice answer.
| Column A | Column B | |
|---|---|---|
| A,B | XX,YY | [email protected] |
| A,C | FF,DD | [email protected] |
I tried to un-nest the first column and keep the remaining columns like this
