Copy & Paste Non Blanks Only

[Igorin]

Hello,

I have this sheet with a very(!) long list that looks something like this
(it has 2 columns only):

Col A | Col B |
Pears | 10 |
Apples | (blank) |
Oranges | (blank) |
Grapes | 5 |
Peaches | (blank) |
Bananas | 13 |

I need to copy only the Non Blank Cells into another sheet so that I get this:

Col A | Col B |
Pears | 10 |
Grapes | 5 |
Bananas | 13 |

How can I do this?


(Note: I posted this question also in Excel Worksheet Functions)

 

[Mike H]

Then why don't you look in worksheet functions and feed back to the
respondents whether their solutions worked

 

[Igorin]

Mike,

I posted both at the same time, i.e. before I got an answer on the functions
forum. And the only reason I posted it here also was that I thought that the
functions forum was not the right one.

besides. Mike, there really is no need to give me that attitude. I mentioned
that I had posted it in the other forum because once I read that you guys
appreciate it when told if this questions was posted elsewhere.

Thanks for the "help"!