Consolidating Data

[tgilmour]

I have a very large table and need to consolidate rows with similar
data.
For example, I want to consolidate rows 2 & 3 to combine the same data
and sum the amount to 35.

client month rep amount company type
Moe January sam 10 shiner wheat
Moe January sam 25 shiner wheat
Moe January sam 30 becks barley

This is probably simple but I'm stumped.

 

[carlo]

I have a very large table and need to consolidate rows with similar
data.
For example, I want to consolidate rows 2 & 3 to combine the same data
and sum the amount to 35.

client month rep amount company type
Moe January sam 10 shiner wheat
Moe January sam 25 shiner wheat
Moe January sam 30 becks barley

This is probably simple but I'm stumped.

Import the Table into Access, make a Query and export it back to
excel....if you have to do it just once.

hth

Carlo