I have a spreadsheet with 2 columns (that are each the result of
different formulas). Both columns contain some blank cells. Column A
contains numbers (12, 11, 10 .. 7), column B contains names.

I need to somehow get Excel to reproduce the lists without blank spaces
in the 2nd column.

For example:

A B
12 John Smith
Fred Bloggs

Peter Piper
Porky Pig
11 Mickey Mouse
Clint Eastwood



Needs to become:

A B
12 John Smith
Fred Bloggs
Peter Piper
Porky Pig
11 Mickey Mouse
Clint Eastwood

Any help is greatly appreciated.

If the solution involves VBA please give me idiot proof steps as to how
to implement it.


--
DavidObeid


------------------------------------------------------------------------
DavidObeid's Profile: http://www.excelforum.com/member.php...fo&userid=2238
View this thread: http://www.excelforum.com/showthread...hreadid=489661