Hi,

Is there a function i could use please to reduce the size of a list. I have
a list of names in col A, with values in B etc, in between certain cells may
be a range of blank cells.

So if i start with a list such as

Bill 2
(blank)
Fred 3
Dave 1
(blank)
(blank)
Wilma 3

The output I would like to generate is

Bill 2
Fred 3
Dave 1
Wilma 3

Thanks