Alright, Can you help me out with a solution then.
Column A has file links.
Column B has multiple tags for these files
Example
File 1 HR, Client Servicing, Creatives
File 2 Strategy, Admin, Creatives
I want to filter on the basis of column B. But the filter should show the following options
1. HR
2. Client Servicing
3. Creatives
4. Strategy
5. Admin
And not
1. HR, Client Servicing, Creatives
2. Strategy, Admin, Creatives
How can i achieve this so that if i select HR i only get file 1 but if select Creatives i get File 1 and 2.