I was wondering, how to work with tags in Tableau in the best way. Let's say, I originally have a small table with football teams and some tags in multiple columns:
Now, I would like to build the sum of fans with all teams from "League 1". Since it could be in 3 different columns, it might be difficult. Is there any good solution how to handle these kind of data?