Hello.

The solution to this might be very simple, but it escapes me. I have a spreadsheet where I want to sort data across the entire spreadsheet according to the value in column A. The problem is that between rows of data I have blank rows and I need to keep it that way.

When I sort with excel it will sort the column perfectly but it will move the blanks to the very bottom of the column and I need them between the rows of data.

What would be the best solution for this? Should I do a sort and then have a macro put a space between the rows that have a different value in column A or is there a better way?

The spreadsheet could look like this:

COLUMN A:

ZZ091
ZZ091
ZZ091
Blank row
XX189
Blank row
ZZ092
Blank row
XX190
XX190
Blank row
XX191
XX191

After running the macro I want it to become:

XX189
Blank row
XX190
XX190
Blank row
XX191
XX191
Blank row
ZZ091
ZZ091
ZZ091
Blank row
ZZ092

Please let me know if the question is not clear and I will try to clarify what I am trying to do. Thanks for your help.