Multiple data entries in one cell for filtering purposes
no, i guess this is the only way.
"hls0401" wrote:
I'm trying to create a cell that has multiple data entries, however when
filtering, it comes up individually. For example:
Movie Title Movie Genre
Matrix Sci-Fi, Action
Avatar Sci-Fi, Action
Die Hard Action
Then, when filtering the table results (pulling down the menu under "Movie
Genre"), I'd like each individual genre to show up:
Sci-Fi
Action
So, if I chose "Action" the results would be:
Matrix
Avatar
Die Hard
But if I chose "Sci-Fi", the results would be:
Matrix
Avatar
Is there a way to do that without making an individual column for
everything? Thanks!
|