Column Array Repeated Sequence of Numbers

[leolapa]

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.

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

Thanks in advance!

[#2]

@leolapa 

=MAKEARRAY(B2*2,1,LAMBDA(r,c,INDEX(A2:A3,IF(ISODD(r),1,2))))

You can try this formula.

 

[#3 · Accepted solution]

@OliverScheurich 

Slightly simpler might be:

=TOCOL(IF(SEQUENCE(,B2),A2:A3),,1)

[#4]

With the bonus that also works in case the number sequence grows to more than two numbers.

Thanks both of you for the great suggestions!