(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?
[] Chocolate
[] Vanilla
[] Strawberry
[] Other: ________
When passing responses to Google Sheets, I get something like:
Chocolate, Vanilla, Apple
Vanilla, Strawberry, Coconut
Chocolate
Chocolate, Strawberry
I want to aggregate my responses in a Google sheet in the following way (in any order):
Chocolate 3
Vanilla 2
Strawberry 2
Apple 1
Coconut 1
How can I achieve this?
Go to Source
Author: simplegamer