I need to use Excel as a "database programme" (even though I know there are other solutions actually built for that). Because of that, I need to find a way to create a filterable column with TAGS/LABELS
What I use right now is plain old table with two columns filled with comma separated values. That makes the data easily filterable (filter > search), but doesn't do the following:
1) When filtering the table by column "Furniture", offer separated values (as in "tables" and "chairs", not "tables, chairs" or "chairs, tables"). 2) When adding new entries/lines to the table, offer existing tags (as in use "tables" instead of "table" under column "Furniture").
Let me be more specific.
I need to create a media list. Each contact is labeled with multiple tags (such as "design", "music", "tourism", "government institution") in ONE COLUMN.
E.g., Users of the media list need to filter out contacts "design". There are rows with columns "cinema, design, exhibition" and "design, tourism". I need them to be able to select under the "filter context menu" specific tags and not the full columns.
That means - not "cinema, design, exhibition" but "cinema", "design" and "exhibition".
If you're familiar with Wordpress administration, its "tags" administration works pretty rad. :)