need to delete blank rows without using 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 blank rows?

--
ALFR

one way:
highlight the rangeF5SpecialBlanks
then EditDeleteRows
HTH

"Arlene" wrote:

need to delete blank rows without using 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 blank rows?

--
ALFR