Hi

Select the whole range of dataSortAscendingmy data has HeadersColumn A
and all the blank rows will be shifted to the end
--
Regards
Roger Govier

Diabolo_Devil wrote:
Is there a quick and simple way of deleting multiple different blank rows
from a sheet? - Other than indivdually clicking on them (with ctrl) and then
deleting.

i.e. removing the blank rows between the other rows of data? (But on a large
scale)

Number Name
B5298 BOWER, RH

G9005 LANDA J
G9456 BHAKRI H

J1482 NIRMAL KUMAR.R

T9574 BAMBER A