Multiple data entries in one cell for filtering purposes
 

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!

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!

Multiple data entries in one cell for filtering purposes
 

It wouldn't be as convenient as you describe, but would the "Custom" option
of the auto filter with the typed genre work? (For example, select custom
then select "contains" and "sci-fi")

"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!