How do I skip blank cells when copying over a range of cells?

[Guest]

I would like to copy a column of values that have blanks between them over to
another column and skip the blanks. The skip blanks feature in paste special
does not help this issue.

 

[Guest]

If you mean that you want to copy a column of cells, but omit the blank cells
(as if they don't exist), try this:

1)Autofilter the range......Data>Filter>Autofilter
2)Set the column filter to be Non-Blanks
3)Copy the range, then paste it where you want it
The blank cells will be left behind.

Example:
A1: Amount
A2: 50
A3: (blank)
A4: 55

Using my suggestion, would A1:A4 would copy/paste as this

A10: Amount
A11: 50
A12: 55

Is that what you meant?

 

[Guest]

Ron,
This is difficult to do when I have a whole spreadsheet of data and don't
want to screw anything else up, right idea though. thanks