Add fields according to names in merged cells

[deciog]

Add merged cells to each name without auxiliary columns, not VBA

I would like to do according to this link made by Bosco #5

HELP REQUIRED FOR ANALYZING DATA

Dear All, I am new to this forum. I have data as per enclosed table but it is not as per the required format. Please help me get some formula so the data can be arranged as per required order for analyzing. I will be highly obliged. Sample DATA TABLE AND REQUIRED FORMAT enclosed.

chandoo.org

I tried to do as explained in # 14 I did not succeed did not work out

Thank you very much in advance

Decio

 

[bosco_yip]

Add merged cells to each name without auxiliary columns, not VBA

I would like to do according to this link made by Bosco #5

HELP REQUIRED FOR ANALYZING DATA

Dear All, I am new to this forum. I have data as per enclosed table but it is not as per the required format. Please help me get some formula so the data can be arranged as per required order for analyzing. I will be highly obliged. Sample DATA TABLE AND REQUIRED FORMAT enclosed.

chandoo.org

I tried to do as explained in # 14 I did not succeed did not work out

Thank you very much in advance

Decio

1] In C2, formula copied across and down :

=SUMIF($A$11:$A$26,$A2,C$11:C$26)

2] Copy merge cells format to helper column >> "Fill blank cells with upper cell value" >> Copy back format from helper column to filled data range >> delete helper column >> Finish

and, see this link in explain "How to fill blank cells with upper cell value"

Fill Blank Cells in Excel Column

In Excel, fill blank cells with values from cells above, manually or programmatically

www.contextures.com

3] Please see attached file

Regards
Bosco