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

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?