Blank Cells

S

Sdbenn90

I would like to copy Col B to Col A skipping the blanks or Zeros.

Example

Col A Col B
7853 7853
1597 1597
7874 0
7961 7874
7990
7994 7961
7990
7994
 
G

Gary''s Student

1. make sure there is a header cell on the top of column B.
2. click on column B
3. Data > Autofilter > Custom > is greater than 0
4. copy column B
5. click on A1 and paste
6. switch off AutoFilter
 
Top