Copy and paste - copy data from multiple rows within one column, to the same rows of another column

[maurzy01]

Hello,

I have searched for a solution to this but I can't seem to find anything. I am using Excel 2007 and I am trying to copy data from multiple rows within one column, to the same rows of another column.

For example:

I have data in column B, from rows 1 to 100. I select data in column B, rows 2, 8, 15, 24 and copy. I select column C row 2 and paste, but the values paste as consecutive rows in C2-C5. instead of C2, C8, C15 and C24.

Any suggestions? I have also played around with paste special but haven't found a way to do this.

Thanks!