Copy & Paste Non Blanks Only

  • Thread starter Thread starter Igorin
  • Start date Start date
I

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?
 
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.
 
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.
 
Thank you!

--
igor


Sheeloo said:
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.
Click to expand...
 
Thank you!

--
igor


sahafi said:
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.
Click to expand...
 
Back
Top