## Forum Discussion

leolapa

Jun 12, 2023Brass Contributor

# 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!

- OliverScheurichGold Contributor
- JosWoolleyIron Contributor
- leolapaBrass ContributorWith the bonus that also works in case the number sequence grows to more than two numbers.

Thanks both of you for the great suggestions!