Copy & Paste Non Blanks Only
 

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?


--
igor

Copy & Paste Non Blanks Only
 

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

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?


--
igor

Copy & Paste Non Blanks Only
 

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.
--
when u change the way u look @ things, the things u look at change.


"Igorin" wrote:

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?


--
igor

Copy & Paste Non Blanks Only
 

Thank you!

--
igor


"Sheeloo" wrote:

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

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?


--
igor

Copy & Paste Non Blanks Only
 

Thank you!

--
igor


"sahafi" wrote:

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.
--
when u change the way u look @ things, the things u look at change.


"Igorin" wrote:

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?


--
igor