I have a column that I want to contain 1 or more tag values, e.g.:
row1: X row2: Y row3: X, Y row4: X, Z row5: X, Y, Z
And then, when I auto-filter on that column, I want my filtering options to simply be:
X Y Z
i.e. if I filter by X, then I should see rows 1, 3, 4, and 5 from above. This, instead of just seeing row 1.
Is such a setup possible?