View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default how do i link up 2 sets of data into 1 set of data in excel

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.