Need to get rid of blank rows without sort

[Guest]

or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?

 

[Anne Troy]

Select the whole column A by clicking on its letter. Edit-->Go
to-->Special-->Blanks, OK. Edit-->Delete, Choose Entire Row. This often
works. Hope I understood.
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

check out auto filter
select column A
<data><Filter><Autofilter>
click on the little arrow at the top of column A and select blanks
select the cells where the row numbers are colored and dlete the rows
turn off autofil

 

[George Nicholson]

You might be able to apply an autofilter (Data>Autofilter), show
"non-blanks" and then copy the results to a new sheet (this doesn't delete
the blank rows as much as it "leaves them behind"). The problem is that
Autofilter isn't crazy about entirely blank rows.

A non-code Alternative:
1) add a column to your data
2) insert a series of sequential numbers into this column (not formulas,
values).
3) Sort on some other field with data/blanks in it (making sure the
sequential # column is included in the sort)
4) Delete the blank rows that float to the top/bottom
5) Re-sort by your sequential value column.

That should put your data back in its original order without blank rows.

In either case, BACKUP first.

HTH,