Same name - multiple data - how to combine
 

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

Same name - multiple data - how to combine
 

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

Same name - multiple data - how to combine
 

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

--
Jeff


"NickHK" wrote:

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

Same name - multiple data - how to combine
 

But Excel has.
Look at DataImport External DataNew Database Query.

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

NickHK

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

--
Jeff


"NickHK" wrote:

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