Thread: Roll up totals for service descriptions

I'm not sure I'm using correct terms. I use Excel 2007 and need to condense totals for like service descriptions into one total.
EX:
Total Amount Service Description
$0.08 12010001
$6.90 12010003
$0.06 12010005
$0.14 12010005
$0.01 12010005
$0.43 12010016
$0.18 12010033
$15.03 12011019
$11.55 12012019

I need it to read
Total Amount Service Description
$0.08 12010001
$6.90 12010003
$0.21 12010005
$0.43 12010016
$0.18 12010033
$26.58 12011019

Pivot Table is the way to go

That is an excellent suggestion but I have to pass the final data as .xls or.csv to be uploaded into Access.

Follow-up
Thank you Special-K you really were right!! I put the data into a Pivot Table it rolled up the totals. I then copied & pasted the results onto a blank page and sent it off for importing into Access.