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:
[TABLE="class: outer_border, width: 609"]
<colgroup><col width="87" span="7" style="width:65pt"> </colgroup><tbody>[TR]
<!--StartFragment--> [TD="width: 87"]AG1[/TD]
[TD="width: 87"]MSC1[/TD]
[TD="width: 87"]MG1[/TD]
[TD="width: 87"]SR1[/TD]
[TD="width: 87"]AA1[/TD]
[TD="width: 87"]CY1[/TD]
[TD="width: 87"]PG1[/TD]
<!--EndFragment--> [/TR]
</tbody>[/TABLE]
next column would show the following:
AG1, MSC1, MG1, SR1, AA1, CY1, PG1
OR like the below if cells are blank,
[TABLE="class: outer_border, width: 609"]
<colgroup><col width="87" span="7" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87"]AG1[/TD]
[TD="width: 87"][/TD]
[TD="width: 87"]MG1[/TD]
[TD="width: 87"]SR1[/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"]PG1[/TD]
[/TR]
</tbody>[/TABLE]
next column would show the following:
AG1, MG1, SR1, PG1
[TABLE="width: 609"]
<tbody>[TR]
[TD="width: 87"][/TD]
<!--EndFragment--> [/TR]
</tbody>[/TABLE]
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!
[TABLE="class: outer_border, width: 609"]
<colgroup><col width="87" span="7" style="width:65pt"> </colgroup><tbody>[TR]
<!--StartFragment--> [TD="width: 87"]AG1[/TD]
[TD="width: 87"]MSC1[/TD]
[TD="width: 87"]MG1[/TD]
[TD="width: 87"]SR1[/TD]
[TD="width: 87"]AA1[/TD]
[TD="width: 87"]CY1[/TD]
[TD="width: 87"]PG1[/TD]
<!--EndFragment--> [/TR]
</tbody>[/TABLE]
next column would show the following:
AG1, MSC1, MG1, SR1, AA1, CY1, PG1
OR like the below if cells are blank,
[TABLE="class: outer_border, width: 609"]
<colgroup><col width="87" span="7" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87"]AG1[/TD]
[TD="width: 87"][/TD]
[TD="width: 87"]MG1[/TD]
[TD="width: 87"]SR1[/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"]PG1[/TD]
[/TR]
</tbody>[/TABLE]
next column would show the following:
AG1, MG1, SR1, PG1
[TABLE="width: 609"]
<tbody>[TR]
[TD="width: 87"][/TD]
<!--EndFragment--> [/TR]
</tbody>[/TABLE]
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!