I wish it was that easy, I tried that first, but thank you.

"jlclyde" wrote:

On Dec 17, 4:08 pm, Phyllis wrote:
I have a spreadsheet that contains blank row to separate data, I need to
remove all the blank rows in order to resort the data for creating labels..

Are you asking how to remove the blank rows? cause you can just sort
the sheet and the blank rows will go to the bottom. If you are
wondering how to sort the sheet and then put the rows back in, then
that is a little trickier.

Jay