Delete duplicates: Sum & Consolidate

[evoxfan]

I have three columns with a cost code, description, and amount such as listed
below.

071.300 Waterproofing Systems $1,000
071.300 Waterproofing Systems $1,000
071.420 Hot Fluid-Applied Water $1,000
074.110 Metal Roof Panels $1,000
074.110 Metal Roof Panels $1,000

I would like to sum and consolidate the amounts for each cost code so that I
do not have duplicates.

Such as with the above list I would like it to show:
071.300 Waterproofing Systems $2,000
071.420 Hot Fluid-Applied Water $1,000
074.110 Metal Roof Panels $2,000

What is the best way to accomplish this?

 

[Dave Peterson]

Check your other post.

I have three columns with a cost code, description, and amount such as listed
below.

071.300 Waterproofing Systems $1,000
071.300 Waterproofing Systems $1,000
071.420 Hot Fluid-Applied Water $1,000
074.110 Metal Roof Panels $1,000
074.110 Metal Roof Panels $1,000

I would like to sum and consolidate the amounts for each cost code so that I
do not have duplicates.

Such as with the above list I would like it to show:
071.300 Waterproofing Systems $2,000
071.420 Hot Fluid-Applied Water $1,000
074.110 Metal Roof Panels $2,000

What is the best way to accomplish this?

 

[Arctic Wolf]

A Pivot Table may help?