Copy a single cell from one sheet and repeat multiple times on another.

[bone7890]

Hey guys I have a list of data that i need to repeat on another list 4 times over and i can't figure out how to do it.

Any advice would be great.


Sheet 1.

List of repeated data

Sheet 2.

List of single items.

Goal

Figure out an easy way to have the single items off of sheet 2 repeated 4 times in a a row on sheet 1.

[Glenn Kennedy]

In Sheet 1, A2, copiwd down:

=OFFSET(Sheet2!$A$1,INT((ROWS($A$2:A2)-1)/4),,,)

[kvsrinivasamurthy]

A non volatile formula. In A2 then drag down
=INDEX(Sheet2!$A$1:$A$14,INT((ROWS($A$2:$A2)-1)/4)+1)

[Pete_UK]

In your example Sheet1 you show Item1 repeated 4 times, but Item2 and Item3 are repeated 5 times each - are these typing mistakes, or indicative of what you want to achieve?

Pete

[bone7890]

@Glenn Kennedy & @ kvsrinivasamurthy Thanks for you help this is perfect,

@Pete_UK that was just a Typo