how do I filter for 1 variable in multiple columns

[California]

how do I filter for 1 variable in 1 row of multiple columns and make sure
that all the data in the selected columns shows. For example I want to
filter all the records (in columns) of each customer who lives in a specific
area

 

[Dave Peterson]

So you may have the indicator value in any of several columns--all in the same
row?

If yes, then I'd use a helper column with a formula like:

=countif(a2:g2,"my key here")

Then filter to show those values greater than 0.

If that key is embedded with other stuff in the cell, I'd use this kind of
formula:

=countif(a2:g2,"*" & "my key here" & "*")
or
=countif(a2:g2,"*my key here*")

Adjust the columns to match your data.