but I can't for the life of me figure out how to insert
the blank rows between every record in the way that you
demonstrated.


It doesn't actually insert rows...

After having deleted the original blanks, it

1) Inserts a column for an index of the original data
2) Creates an index of the original data
3) Copies that index to the rows below your data range
4) Resorts the new range, which includes both your data,
and the second copy of the index.

This leaves you with your original row of data, and a new
row blank row, which has been placed based upon the
original index, and the copied index, each having the same
values in them...

sort of like turning

1 data
2 data
3 data
1
2
3

into:

1 data
1
2 data
2
3 data
3

through sorting.

It's a good solution.... can in some cases work more
quickly than progressing through a loop and inserting.