merge two data sets one unique

C

CESTOTT

I am attempting to merge two excel worksheets. One has a set of unique ID
numbers with accompanying data. The other has ID duplicative numbers, but I
want corresponding info to be copied as appropriate.
 
P

PancakeBatter

CESTOTT said:
I am attempting to merge two excel worksheets. One has a set of unique ID
numbers with accompanying data. The other has ID duplicative numbers, but I
want corresponding info to be copied as appropriate.
Click to expand...
 
P

PancakeBatter

Hi Cestott-

Maybe something like this?

In unique ID table, insert a copy of ID column adjacent to ID column

In duplicative ID table, insert blank column adjacent to ID column. Use a
formula with Row and Concatenate functions to create a unique ID for each ID
(ID+ rownumber).

Copy unique ID table after duplicative ID table. Sort on new column. Use
custom Data filter to select concantenated IDs that start with ID.

PB
 
Top