Cancatenate Multiple Cells in Rows

[slohman]

Is there a way to concatenate multiple rows if A2:A6 is True then concatenate B2:C6 with DASH into E2 with a COMMA in between.

A1	B1	C1		E1
TRUE	SW57	Swing Post Double		SW57 - Swing Post Double, SW84 - St Swing Post Double (electro-polished), etc
TRUE	SW84	St Swing Post Double (electro-polished)
TRUE	SW84-1	St Swing Post Double (Powder-coated)
FALSE	SW65	Swing Post Triple (2+1)
TRUE	SW130	Swing Post 4 Bay Snr/Jnr

<tbody>
</tbody><colgroup><col span="2"><col><col><col></colgroup>

TIA

 

[shaowu459]

Yes, if you have Office 365, TEXTJOIN function will solve this problem very easily.

 

[slohman]

Thanks could you explain what the formula would need to look like.

 

[shaowu459]

The formula looks like:

=TEXTJOIN(",",,IF(A1:A5,B1:B5,""))

Ctrl shift enter for the array formula.

"," measn the delimiter is ",", TEXTJOIN will concatenate B1:B5 if A1:A5 is TRUE.

formula returns:1,3,4 for below table.

TRUE	1
FALSE	2
TRUE	3
TRUE	4
FALSE	5

<colgroup><col width="80" span="2" style="width:60pt"> </colgroup><tbody>
</tbody>