There are probably several solutions, here is my suggestion.

Part I -

Sort the entire workbook by column A ascending, then by Column B
ascending.

Scan through the sorted data and you should now see all the blank "A's"
together. within in this group you will all the blank B's together, and
all the B's with info together as well. Since this sort has now grouped
all the cells that are blank together, you can find where the data
begins to have info in B but nothing in A. Type in "unnassigned" in
the first row in A where there is info in B, then drag down as needed.

Part II -

This sort has also grouped the cells that are blank in A with the cells
that blank in B in one matrix. Go over to column C and copy the "n"
rows of data that need to be moved to D. You can now paste the info in
D, and offset it any way you please (in this case you are going to
offset by one row?).

That should do it.

Note - If the data was previously sorted in a specific order that you
wanted to preserve, you will need to insert a temporary column in A,
and then number all the rows (1 through 14,000). This will be the
reference column, when you are done massaging your data you can resort
the list by the new column A (the reference #'s), and then delete it
when you are done.

Let me know if you want more detail.


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=473523