Hi,

I have a sequence of two numbers 1 and 15 stacked on top of each other "=SEQUENCE(2,,,14)".

I just want to have that pattern repeated 4x in one single "spilled" array, like this:

1
15
1
15
1
15
1
15

I tried to accomplish this by using MAKEARRAY and TOCOL but I keep getting the #CALC! error.

Excel_Rept_Seq_Numbers.png

What am I missing here? Any help is greatly appreciated...

Thanks in advance!

P.S.:
Same question also posted on Microsoft Tech Community forum: https://techcommunity.microsoft.com/...845224#M194666