My example is wrong. I'm looking forthe data to look like this.
X12345 200 4000 Smith Jones
Y12345 300 3000 Johnson Howard

"Donna YaWanna" wrote in message
...
I have files that contain a header row and then thousands of rows of data.
Column A is a customer identifyer label that is unique. There's only 1 row
per customer.
EXCEPT for my problem. In some cases, we've repeated the rows to split off
have of the data in the other cells to be assigned to 1 salesman amd the
other half to another salesman.
Now I need to merge them all back together so that...

X12345 100 2000 Smith Jones
X12345 100 2000 Smith Miller
Y12345 300 3000 Johnson Howard
becomes....
X12345 200 4000 Smith Miller
Y12345 300 3000 Johnson Howard

So the amounts are added and the name that appears first is the one that
is
used.

Is there an easy way to do this?
Thanks