Blank rows

[DavidObeid]

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.

 

[Max]

Try this on a spare copy

Select col B
Press F5 > Special > Blanks > OK
Right-click > Delete > Entire row > OK

 

[cvolkert]

One solution that doesn't necessarily need to use VBA would be an
advanced filter. The attached file shows an example. In the file,
columns A&B is the master list, D&E are the output list and G is the
criteria. Select Data/Advanced Filter - copy to new location - select
the entire master list for the list range, select the title and <> cell
for criteria, and select the column headings in D&E for the output.
Click OK and you will be set. This solution requires that you label
your columns (Name and Number in my example) and use these in the
criteria and output. Let me know if you have more questions - Chad


+-------------------------------------------------------------------+
|Filename: Blanks.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4085 |
+-------------------------------------------------------------------+

 

[DavidObeid]

It doesn't seem to recognise the blank cells as blanks?

 

[DavidObeid]

Thanks Chad!

Problem solved

 

[Dave Peterson]

How about just selecting your range (include all the columns in that range),
then:

Data|Sort
The blank cells should be grouped together so it should be easy to delete them.

 

[DavidObeid]

Simple solutions are always the best

Thanks Dave

 

[Max]

It doesn't seem to recognise the blank cells as blanks?

Sorry, think I missed the significance of this line in your orig. post

.. 2 columns (that are each the result of different formulas).

Glad to see you've got other insights which worked for you since.