Blank rows
 

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

Blank rows
 

Try this on a spare copy

Select col B
Press F5 Special Blanks OK
Right-click Delete Entire row OK
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"DavidObeid" wrote
in message ...

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

Blank rows
 

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 |
+-------------------------------------------------------------------+

--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=489661

Blank rows
 

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

:confused:


--
DavidObeid


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

Blank rows
 

Thanks Chad!

Problem solved :)


--
DavidObeid


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

Blank rows
 

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 wrote:

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

--

Dave Peterson

Blank rows
 

Simple solutions are always the best :)

Thanks Dave


--
DavidObeid


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

Blank rows
 

"DavidObeid" wrote:
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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--