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!