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!