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