I need to easily copy non-adjacent cells from one column to another. I have searched the web to no avail. It would seem easy to do but excel fills in the blank that was in the original column when the copy goes to C column. If I try to Copy A1 & A3 to C1 & C3 Using the CTL Key (high liting A1 & A3)of course... I get the result with the blank space filled. Any ideas to copy & keep intact. I prefer not to copy the whole column & deselect because data exists in the C column. Thanks
a b c
1 22
2
3 13
a b c
1 22
2 13
3
Bookmarks