Hi,

I would like to consolidate a table (see below).
Where:
Header : row 1
key columns (C & G),
sum columns (E & F) and
keep 1st data on columns (A, B, D, H, I & J)

I tried to follow some other codes from other post but unfortunately my excel VBA is very limited. I hope someone can share and guide me how to achieve the desired output.

Thank you.

excel.jpg