Ask Your Question

Revision history [back]

There is no easy solution, but I may have a couple of ideas that could help.

First, if there is any way to match the rows in the two blocks of data by visual inspection alone, try to use that ability to your advantage. See if you can create a sort key column for the second block based on the first block using VLOOKUP or other formula-based approaches.

Second, if the first idea is not possible, create a sort key column for each of the data blocks. Assign a key to each row of the first block. This can be as simple as entering the row number or other sequential number (which you could do by formula or autofill).

Next, use whatever method is possible to match rows in the second block to rows in the first block. For each match, enter the sort key of the first block into the corresponding column and row of the second block.

When you are done with whichever of the two approaches you choose, sort the second block on the sort key column. This should re-sync the second block with the first block. Now you can delete the sort keys and re-join the two data blocks.

As you can see, either approach is going to take some work -- but hopefully less than consulting your popsicle sticks and copying and pasting half-rows of data.

There is no easy solution, but I may have a couple of ideas that could help.

First, if there is any way to match the rows in the two blocks of data by visual inspection alone, try to use that ability to your advantage. See if you can create a sort key column for the second block based on the first block using VLOOKUP or other formula-based approaches.

Second, if the first idea is not possible, create a sort key column for each of the data blocks. Assign a key to each row of the first block. This can be as simple as entering the row number or other sequential number (which you could do by formula or autofill).

Next, use whatever method is possible to match rows in the second block to rows in the first block. For each match, enter the sort key of the first block into the corresponding column and row of the second block.

When you are done with whichever of the two approaches you choose, sort the second block on the sort key column. This should re-sync the second block with the first block. Now you can delete the sort keys and re-join the two data blocks.

As you can see, either approach is going to take some work -- but hopefully less than consulting your popsicle sticks and copying and pasting half-rows of data.

(Please click the check mark next to my post if you believe it to be the best answer to your question.)