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

maurzy01

New Member
Joined
Sep 29, 2014
Messages
4
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!
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,108,612
Messages
5,523,896
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top