asked on

EXCEL Match data rows in excel. (not same amount of values)

I have 4 columns of data.
I need the 1st row of set data in column 1 and 2 to match the first row of set data column 3 and 4
Below is an example of what the data looks like now

COL1 COL2 COL3 COL4
Row 1 8810 Green 7228 Green
Row 2 8810        Green 7228 Green
Row 3 8810 Green 7228 Green
Row 4 7228 Green
Row 6 9086 Green 8810 Green
Row 7 8810 Green
Row 8               8810 Green
Row 9 8810 Green
Row 10 9044 Green
Row 11 9086 Green
Row 12 9086 Green

      Ideally I need the data like this
Row 1 7228 Green
Row 2 7228 Green
Row 3 7228 Green
Row 4 7228 Green
Row 5 8810 Green 8810 Green
Row 6 8810      Green 8810 Green
Row 7 8810 Green             8810 Green
Row 8 8810 Green
Row 9 9044 Green
Row 10 9086 Green 9086 Green
Row 11 9086 Green


      So essentially I need the data in col 1 and col 2 to have cells inserted only for column 1 and 2 and push that data down to where it will line up with the first row of the data set in col 3 and col 4.

I am not sure that a standard vlookup will work for this scenario, Any ideas?

ASKER CERTIFIED SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Professor J