Forum Discussion

leolapa's avatar
leolapa
Brass Contributor
Jun 12, 2023
Solved

Column Array Repeated Sequence of Numbers

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!

      • leolapa's avatar
        leolapa
        Brass Contributor
        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!

Resources