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?

 

[Sheeloo]

Click on Data->Filter->Auto Filter
Pick NON BLANKS from the drop down for the second col
Copy the filtered rows and paste where you want.

 

[sahafi]

Filter your list (Auto Filter). There should be an option (No Blanks), select
that option, and it should do the trick. Or us Custom filter and set a
criteria like doesn't equal " ".

h.t.h.

 

[Igorin]

Thank you!

--
igor

Click on Data->Filter->Auto Filter
Pick NON BLANKS from the drop down for the second col
Copy the filtered rows and paste where you want.

 

[Igorin]

Thank you!

--
igor

Filter your list (Auto Filter). There should be an option (No Blanks), select
that option, and it should do the trick. Or us Custom filter and set a
criteria like doesn't equal " ".

h.t.h.