Need to copy 60x2 cells, ten times each down

[dbohle17]

Sorry for a confusing title, but I cant think of a better way to put it. Basically, I have 120 values (two columns of 60) and need each row of 2 values copied 10 times below the original.
i.e.
1,2
1,3
1,4
.....

to
1,2
1,2
1,2
1,2
1,2
1,2
1,2
1,2
1,2
1,2
1,3
1,3
1,3
....


any help would be much appreciated!

[Richard Buttrey]

Hi, and welcome to the forum.

One way assuming data is in A1:B60 is use a couple of helper columns

D1:
=OFFSET($A$1,INT((ROW()-1)/10)+1-1,0)
E1:
=OFFSET($B$1,INT((ROW()-1)/10)+1-1,0)

Copy D1:E1 down for 600 rows.

Regards

[jason.b75]

Assuming your list in A2:B61, with the range to copy starting in A70

=INDEX(A$2:A$61,INT((ROWS(A$70:A70)-1)/10)+1)

Copy down and right as needed.

[dbohle17]

Thanks! worked great!

[rollis13]

Have a try with this:

Please Login or Register  to view this content.

[Cutter]

@dbohle17

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save