Jeff,
Depending what this other source is, have you tried a query with the SQL
Group By on FirstName and LastName ?
That way, you get the correct into Excel initially.

NickHK

"Jeff" wrote in message
...
Greetings -
I have a workbook in which I pull a bunch a data from another source. The
rows have the same name of a person, but each row has some small pieces
that
are different (each in a seperate column). I would like to combine the
similiar people and their info into one row. For example, the data is
now:

Hire Date Term Date Benefit Date Birthdate First Name
Last Name
1/2/02
Jeff Jones
3/23/06
Jeff Jones
4/2/02
Jeff Jones
4/7
Jeff Jones
6/6/03
Barry Smith
10/6/03
Barry Smith
5/25/06
Barry Smith
10/4/04
Tom Jerid
9/4/04
Tom Jerid
1/23/06
Tom Jerid
6/12
Tom Jerid

And I would like for it to look like:

Hire Date Term Date Benefit Date Birthdate First Name
Last Name
1/2/02 3/23/06 4/2/02 4/7
Jeff Jones
6/6/03 5/25/06 10/6/03
Barry Smith
9/4/04 1/23/06 10/4/04 6/12
Tom
Jerid


I have tried everything and I am now officially stuck. Any help would be
great. Thank you.
-----
Jeff