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: https://docs.google.com/spreadsheets/d/1aP7sDTf0xlxQFK51wiswiXcIMKvUNL_3hpi0qhDCvx4/edit#gid=0
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.