Delete duplicates: Sum & Consolidate
 

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?

Delete duplicates: Sum & Consolidate
 

Check your other post.

evoxfan wrote:

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

Delete duplicates: Sum & Consolidate
 

A Pivot Table may help?

"evoxfan" wrote:

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?