i want to concatenate 2 sets of data into 1 set. how do i line up like rows.
the basic dat sort doesnt work as not all of the data are the same in the 2
sets. i know you use concatenate somehow. the example is data set 1 is name
and phone numbers , data set 2 is names and addresses. i want to combine them
into one data set with names, phone numbers,and addresses.

Mike,
Use VLOOKUP with "name" as search argument to retrieve the
corresponding data.

For example, use VLOOKUP to get the address data to be added to the 'phone
data for a given name.

Assuming name and telephone are in columns A& B of Sheet1 and name & address
are in columns A & B of Sheet2 then in column C (Cell C2) of sheet1 put

=VLOOKUP(A2,Sheet2!A:B,2,0)

this will match name in A2 against name in Sheet2 and return address from
column B.

HTH

"mike" wrote:

i want to concatenate 2 sets of data into 1 set. how do i line up like rows.
the basic dat sort doesnt work as not all of the data are the same in the 2
sets. i know you use concatenate somehow. the example is data set 1 is name
and phone numbers , data set 2 is names and addresses. i want to combine them
into one data set with names, phone numbers,and addresses.

Excuse me Gord...Mike, Are you asking about one worksheet ? - do you need a
separate cell containing the merged info texts in every row...and then sort
it under one column containing the merged texts....and then do something else
??

"Toppers" wrote:

Mike,
Use VLOOKUP with "name" as search argument to retrieve the
corresponding data.

For example, use VLOOKUP to get the address data to be added to the 'phone
data for a given name.

Assuming name and telephone are in columns A& B of Sheet1 and name & address
are in columns A & B of Sheet2 then in column C (Cell C2) of sheet1 put

=VLOOKUP(A2,Sheet2!A:B,2,0)

this will match name in A2 against name in Sheet2 and return address from
column B.

HTH

"mike" wrote:

i want to concatenate 2 sets of data into 1 set. how do i line up like rows.
the basic dat sort doesnt work as not all of the data are the same in the 2
sets. i know you use concatenate somehow. the example is data set 1 is name
and phone numbers , data set 2 is names and addresses. i want to combine them
into one data set with names, phone numbers,and addresses.