I want to make a search table for my school library. Each row contains a book. But its book can have multiple authors (if we talking about proceedings of a seminar etc they can be 10+) and also multiple subjects (like 10+).
I like how when you format an area into a table all columns get filters, u press the arrow icon and you get all the possible values of that column. By checking/unchecking you get the rows with said values. This is what I want. But in case of author & subject where in each row you can have different values either I must do like 15-20 columns for each or put all in a single cell (say comma delimited list ).
In this case how can I include them in my filters? I know you can go to advanced filters and choose 'contain' and write what you want but I would like to show e.g. the list of subjects the user could choose from.
Any ideas?