Many Country Code in same Google Sheet cell

[rockhead28]

I am creating a product dashboard with the goal of filtering types of products and it will reflect which country holds the product. Its linked to google sheet, Example table below:

Product | CountryAvailable
Television | US,PH,JP,AU
Table | US,CN,SG,NZ
Chair | IN,PH,SG,AU,NZ

My problem is getting map dashboard to reflect every countries after filtering the product. And if I were to split every country code into a new row at the raw data level (GSheet), there would be many duplication. Any advise?

[sam8]

Interesting question!

I don't think there is any way to get Looker Studio to accept multiple country codes in one cell. I think you'd have to split the codes in the data and find a way to present that well despite the duplication.