Use SEQUENCE and ARRAYFORMULA together

Question

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

Answer 1

ArrayFormula() won't work as expected when used with functions that by default accept arrays.

Try something like this instead:

=arrayformula(split(rept(A2:A4&"❄️",B2:B4),"❄️"))