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