HELP ASAP get rid of blank rows without sort
 

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?

--
ALFR

duplicate posting

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

--
ALFR

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?

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.