(Note the “Other” choice, so my question is not a duplicate unless I overlooked the question where it was asked when searching).
On a Google form, I made a checkbox question in the following format:
What flavors do you like?
() Other: ________
When passing responses to Google Sheets, I get something like:
Chocolate, Vanilla, Apple
Vanilla, Strawberry, Coconut
I want to aggregate my responses in a Google sheet in the following way (in any order):
How can I achieve this?