rette
New Member
- Joined
- Oct 29, 2015
- Messages
- 6
Have 6 columns of data (like below but some columns could be blank or even all) and then a column that will summarize the preceding information such as the examples below:
<colgroup><col width="87" span="7" style="width:65pt"> </colgroup><tbody>
<!--StartFragment-->
<!--EndFragment-->
</tbody>
next column would show the following:
AG1, MSC1, MG1, SR1, AA1, CY1, PG1
OR like the below if cells are blank,
<colgroup><col width="87" span="7" style="width: 65pt;"></colgroup><tbody>
</tbody>
next column would show the following:
AG1, MG1, SR1, PG1
<tbody>
<!--EndFragment-->
</tbody>I need a formula that will summarize, skip blanks and add the commas. Please help - had it figured out but computer crashed in the middle but my export was a csv and I stupidly hadn't converted to an XLS yet and so it flattened the formula and I couldn't restore and now I can't re-create.
Thanks!
AG1 | MSC1 | MG1 | SR1 | AA1 | CY1 | PG1 |
<colgroup><col width="87" span="7" style="width:65pt"> </colgroup><tbody>
<!--StartFragment-->
<!--EndFragment-->
</tbody>
next column would show the following:
AG1, MSC1, MG1, SR1, AA1, CY1, PG1
OR like the below if cells are blank,
AG1 | MG1 | SR1 | PG1 |
<colgroup><col width="87" span="7" style="width: 65pt;"></colgroup><tbody>
</tbody>
next column would show the following:
AG1, MG1, SR1, PG1
<tbody>
<!--EndFragment-->
</tbody>
Thanks!