Excel combine rows dollar amount with matching row values

microsoft excelpivot table

I've ran into a problem with Excel, I have the below table

enter image description here

Basically, I'm trying to figure out how to make all rows that have the same product key combine, except calculating the dollar amount for each matching row for that new row. For example, rows 8 and 9 would match on row E, and then add 3.99 and 7.99. The result would be only one row with all the same information except for Dollars which would be 11.98.

Can anyone help me figure out how to go about doing this?

Best Answer

Sounds like a job for pivot table!

Highlight your table and go to Insert → pivot table and arrange it how you want. I'd do the following -

enter image description here

Related Question