Counting comma seperated value as mutiple counts

[Doy]

I have a column named "flavor" and it can have values such as:

- Dark Chocolate
- Oreo Birthday
- Dark Chocolate,Dark Chocolate,Dark Chocolate
- Dark Chocolate,Oreo Birthday

In the case where there are multiple flavors in 1 record, I would like to count them individually. Here is how my table shows these multiple flavors now:

Instead of that whole string being counted once, I would like for Dark Chocolate to be counted 3 times. Is this possible? Or do I have to make a separate table?

[ArkadyZagdan]

@Doy 

Yes it is doable - but not with Looker Studio.
Its a data reporting solution tool not a data cleansing one. You should first clean the data using any data transformation tool like Dataprep, Datafusion or SQL considering data is in BigQuery or Cloud Storage.
Optionally you can clean your data directly in Google Sheets that is your original data source.