Hi all,
I am in a situation where if I could figure out how to correct
sort AlphaNumeric Data sequentially with adding empty cells where the
sequence skips I could save myself Hours upon HOURS of work. Here is
what I need help with....

I have 1 columns of data for example ( the < before the data is the
cell number)....


<A1 D00018
<A2 D00019
<A3 D00023
<A4 D00030
<A5 D00031
<A6 D00033
<A7 D00034
<A8 D00042
<A9 D00045
<A10 D00046
<A11 D00049
<A12 D00051


What I wish for is a macro or some 'sort' function to do is include
blank cells where the numbers skip. I.E. the output to look like
this....


<A1 D00018
<A2 D00019
<A3
<A4
<A5
<A6 D00023
<A7 D00024
<A8 D00025
<A9
<A10 D00027
<A11
<A12 D00029
<A13
<A14 D00031
<A15 D00032
<A16
<A17 D00034


Only alternative I have is going through and manually putting blank
cells in where the sequence skips. I have to do this for over 10000
entries =/ IS there a link to a solution for this already as im new
to
the forums? Or anyone have a step by step way of completing this
task?
ANYTHING would be GREATLY appreciated!! Thanks much!!