Match lists of unique ID's by inserting rows

JugglerJAF

Active Member
Joined
Feb 17, 2002
Messages
271
I have two columns of data with a unique id in each column.

Some of the id numbers are only in the first column, some are only in the second and some are in both.

What I need to do is to insert rows (or cut and paste to move data down) so that the numbers match up on each row.

Example
Column A has 1,2,3 & 5 in rows 2 to 5 inclusive (row 1 being a header row)
Column B has 1,4,5 & 6 in rows 2 to 5 inclusive (row 1 being a header row)
What I need as the final "solution" is for Column A to have 1,2,3,4 & 5 in rows 2,3,4 & 6 respectively and for column B to have 1,4,5 & 6 in rows 2,5,6 & 7 respectively.

Help!! (thanks)
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,118,734
Messages
5,573,910
Members
412,555
Latest member
mark84
Top