Same name - multiple data - how to combine

J

Jeff

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.
 
N

NickHK

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
 
J

Jeff

Hi - unfortnately, the other source doesn't have that function, it is a
little out-dated, but all I have for now... help.
 
N

NickHK

But Excel has.
Look at Data>Import External Data>New Database Query.

The output from the other source must be in some recognisable format, so you
can query it.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top