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?
(Note: I posted this question also in Excel Worksheet Functions)
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)