Excel 2010: Aggregating rows with detail
Posted on 2014-01-28
I have a sheet that has multiple rows with the same product name.
It has columns that need to be aggregated. The issue is that no matter which way I do it the remaining columns do not show up.
The sheet looks like:
A C 0.15 1,200 500
B B 0.16 50 10
A C 0.15 100 100
I wish to get:
A C 0.15 1,300 600
The problem is that every thing I have tried totals fine, but doesnt give me the "C" and the 0.15 in the above example.
Anyone have any ideas?