Can I populate a Google Sheet column using a query that finds all the matches from another sheet?

I have two Google Sheets. Sheet1 is categorizing the "Places" from Sheet2. I want to populate the "Categories" column on Sheet2 with all the headers from Sheet1 whose columns contain the given "Place". For example, the "Categories" cell for "Alabama" should contain "Bands, States" (or whatever concatenation format can be done).

Google* google spreadsheetsSpreadsheetsMicrosoft Excel

Last Comment

Anthony Pangilinan

8/22/2022 - Mon

Professor J

1/11/2020

this is the formula to put in Sheet2 B2

=TextJoin(",",True,FILTER(Sheet1!$A$1:$C$1,INDEX(Sheet1!$A$2:$C$20,MATCH(A2,Sheet1!$A$2:$A$20))=A2))

Anthony Pangilinan

1/13/2020

ASKER

Thanks for the reply! That seems to be working properly for cases when the "Place" occurs on the same line in multiple columns, but not when it is on different lines between columns. "Alabama" looks like the only case it's completely working on.