HELP ASAP get rid of blank rows without sort

A

Arlene

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?
 
H

Harlan Grove

Arlene wrote...
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?
Click to expand...

Simplest way is to select the entire range, run Data > Filter >
Autofilter, choose (Blank) in the drop-down list for any of the columns
which will filter out rows in which that column contains blanks, delete
the filtered rows, and run Data > Filter > Autofilter again to clear
the autofilter.
 
Top