I want to create sequences of cells of repeating digits using the function SEQUENCE
. However I also want to gather them all in one big array using ARRAYFORMULA
and then FLATTEN
, but it doesn't seem to work the way I expect.
Here an example of where I use the formula SEQUENCE(1,Repeat,Value,0)
to create output sequences for each individual lines. I want to produce all of these lines at once in one formula and then FLATTEN
them all in one big array.
Value Repeat Output (over multiple columns)
2 3 2 2 2
3 2 3 3
4 3 4 4 4
So I tried to write ARRAYFORMULA(SEQUENCE(1,Array_of_Repeats,Array_of_Values,0))
but this only produces the following output :
2
3
4
over a single column (no further columns are produced), so only the starting column ...
See example here