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.
<tbody>
</tbody><colgroup><col span="2"><col><col><col></colgroup>
TIA
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