<div>
this is the formula to put in Sheet2 B2<br />
<br />
=TextJoin(&quot;,&quot;,True,FILTER(<wbr />Sheet1!$A$<wbr />1:$C$1,IND<wbr />EX(Sheet1!<wbr />$A$2:$C$20<wbr />,MATCH(A2,<wbr />Sheet1!$A$<wbr />2:$A$20))=<wbr />A2))
</div>


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))

Martin Nguyen

Developer

Anthony Pangilinan

<div>
Thanks for the reply! That seems to be working properly for cases when the &quot;Place&quot; occurs on the same line in multiple columns, but not when it is on different lines between columns. &quot;Alabama&quot; looks like the only case it's completely working on.<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/01_w03/1440831/function1.PNG" target="_blank" title="function1.PNG (21 KB)"><img alt="function1.PNG" class="file-block lazyload" style="max-width: 795px;" data-src="https://filedb.experts-exchange.com/incoming/2020/01_w03/1440831/function1.PNG" /></a>
</div>


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.
function1.PNGhttps://filedb.experts-exchange.com/incoming/2020/01_w03/1440831/function1.PNG

function1.PNG

<div>
Can you please share the dummy file link here, so that I build the formula there?
</div>


Can you please share the dummy file link here, so that I build the formula there?

<div>
Yeah that would be helpful, wouldn't it?<br />
<br />
<a href="https://docs.google.com/spreadsheets/d/1EBtEqJs14BDXf19qEXHxSwWGJkjlc2y5L3NU23i3L-A/edit?usp=sharing" rel="ugc">https://docs.google.com/spreadsheets/d/1EBtEqJs14BDXf19qEXHxSwWGJkjlc2y5L3NU23i3L-A/edit?usp=sharing</a>
</div>


Yeah that would be helpful, wouldn't it?

https://docs.google.com/spreadsheets/d/1EBtEqJs14BDXf19qEXHxSwWGJkjlc2y5L3NU23i3L-A/edit?usp=sharing [https://docs.google.com/spreadsheets/d/1EBtEqJs14BDXf19qEXHxSwWGJkjlc2y5L3NU23i3L-A/edit?usp=sharing]

<div>
<div class="content wysiwyg-content">
<a href="https://filedb.experts-exchange.com/incoming/2020/01_w02/1440674/sheet1.PNG" target="_blank" title="Sheet1 (10 KB)"><img alt="Sheet1" class="file-block lazyload" style="max-width: 356px;" data-src="https://filedb.experts-exchange.com/incoming/2020/01_w02/1440674/sheet1.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2020/01_w02/1440675/sheet2.PNG" target="_blank" title="Sheet2 (10 KB)"><img alt="Sheet2" class="file-block lazyload" style="max-width: 358px;" data-src="https://filedb.experts-exchange.com/incoming/2020/01_w02/1440675/sheet2.PNG" /></a><br />
I have two Google Sheets. Sheet1 is categorizing the &quot;Places&quot; from Sheet2. I want to populate the &quot;Categories&quot; column on Sheet2 with all the headers from Sheet1 whose columns contain the given &quot;Place&quot;. For example, the &quot;Categories&quot; cell for &quot;Alabama&quot; should contain &quot;Bands, States&quot; (or whatever concatenation format can be done).
</div>
</div>


sheet1.PNG

sheet2.PNG




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).

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

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

Google

google spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.