Wayne,

Select the entire data set.
Sort by the column with the blanks.
The blank cells will sort to the bottom allowing you
to delete the rows as a group.

Regards,
Jim Cone
San Francisco, USA


"W. Watson" wrote in message
ink.net...
Is it possible to remove rows that are blank in some column?

Suppose I have

a 4
b 6
8
d 2
e 9

And want to remove rows with a blank in column 1 and collapse the whole array to
get:

a 4
b 6
d 2
e 9
Wayne T. Watson (Watson Adventures, Prop., Nevada City, CA)
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet
"Academic disputes are vicious because so little
is at stake." -- Anonymous
Web Page: <home.earthlink.net/~mtnviews