Sheets – Aggregate checklist responses from Google forms with “Other” as an option

(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, 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