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.

[TABLE="width: 893"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD] [/TD]
[TD]E1[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD]SW57[/TD]
[TD]Swing Post Double[/TD]
[TD][/TD]
[TD]SW57 - Swing Post Double, SW84 - St Swing Post Double (electro-polished), etc[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD]SW84[/TD]
[TD]St Swing Post Double (electro-polished)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD]SW84-1[/TD]
[TD]St Swing Post Double (Powder-coated)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD]SW65[/TD]
[TD]Swing Post Triple (2+1)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD]SW130[/TD]
[TD]Swing Post 4 Bay Snr/Jnr[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col span="2"><col><col><col></colgroup>[/TABLE]

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.

[TABLE="width: 160"]
<colgroup><col width="80" span="2" style="width:60pt"> </colgroup><tbody>[TR]
[TD="width: 80, align: center"]TRUE[/TD]
[TD="width: 80, align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]5[/TD]
[/TR]
</tbody>[/TABLE]