I wish to merge all empty cells in a selection with the first non
empty cell above retaining that value e.g.

Smith
<empty
<empty
Jones
Bloggs
<empty

Smith)
)Merged
)
Jones
Bloggs)
)Merged

and so on...

any ideas?

Pete