How can I have it increment a number that repeats 12 times, so that it looks like this:

1

1

1

1

1

1

1

1

1

1

1

1

2

2

2

2

2

2

2

2

2

2

2

I've been trying to tweak this formula, but with no success: =ARRAYFORMULA(TRANSPOSE(SPLIT(QUERY(REPT(1&",",12), , 999^99), ",")))

Thanks.

CodePudding user response：

Try-

=ARRAYFORMULA(ROUNDUP(SEQUENCE(195)/12,0))

CodePudding user response：

Try

=arrayformula(INT(sequence(12*195,1,0,1)/12) 1)