Copy and Paste every other line (thousands of times)

[brose99]

........A..........B..........C.........
1...*-7.5*....*12*....*-32*....(paste)
2....-7.5........12........-32......(copy)
3....*12*......*-7*.....*19*....(paste)
4.....12.........-7.........19.......(copy)


I am trying to complete a huge copy and paste job where I copy the three sets of numbers in the even lines and paste them in the blank lines above them. The problem is that I need to do this for thousands of lines and doing it manually (i.e. arrowing down and manually hitting paste every other row) will take me hours. Is there a quicker way for me to do this?

Thanks in advance!

[FDibbins]

Instead of copying, use =A1 (or whatever the cell ref is), then just copy that down as needed?

[leelnich]

Hi all- Paste the following formula in D1.

=OFFSET(D1,ISODD(ROW()),-3)

1) Copy D1 into E1:F1, then copy D1:F1 down as far as required.
2) Select and copy ALL the columns D:F cells you pasted the formula in.
3) Select A1, right-click, and Paste Values

Row\Col	A	B	C	D	E	F
1				2.1	2.2	2.3
2	2.1	2.2	2.3	2.1	2.2	2.3
3				4.1	4.2	4.3
4	4.1	4.2	4.3	4.1	4.2	4.3
5				6.1	6.2	6.3
6	6.1	6.2	6.3	6.1	6.2	6.3

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[brose99]

That's what I'm looking for! Thanks, Leelnich!