• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

include blank interspersed rows when sorting in Excel

My spreadsheet has a blank row between each data row.  I want to keep that format after sorting the entire spreadsheet.  How can I prevent the blank rows from sorting to the bottom?
0
bigjack
Asked:
bigjack
  • 2
1 Solution
 
patrickabCommented:
Sort as normal - all the blank rows will go to the bottom of the list. Write a brief routine which you start when the cell pointer is on the top row of what you have just sorted and which does the following:

if cell contents<>"", move down one cell, else quit
insert a row
call this routine again

Hope that helps
0
 
turn123Commented:
bigjack,
No comment has been added lately (299 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to patrickab http:#8176645

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --

Thanks,

turn123
EE Cleanup Volunteer
0
 
bigjacksCommented:
I hope this closes this question.
0
 
turn123Commented:
bigjacks,

What are you referring to?

Turn123
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now