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