Try this in B1 and copy down till the required range (till row no which is 5
times the last row in A)
=INDIRECT("A" & (INT((ROW()-1)/5)+1))

"hab" wrote:

I am trying to create a formula that will take a list i have a break it out
to repeat the list 5 times

ie
current list
1
2
3
4

want it to say
1
1
1
1
1
2
2
2
2
2
3
3
3
3
3

i rather do this through a formula than macro since i am new to macros, but
if you can help me with an easy macro i can follow i am all for it
thanks