Select All Columns Where Cell In Columns Contain A Word - Google Sheets

by Keran Smith   Last Updated October 18, 2019 21:03 PM - source

I am looking for a query formula that will allow me to select all columns (entire column) that contain a specific word within the column.

You can see a test sheet here:

For this example, I would like a query that would scan Sheet1 and select all columns that contain the words "Adam". This would select Columns A-D.

Any help would be appreciated.


Related Questions

Adding missing dates to Google Sheets

Updated September 20, 2019 15:03 PM