Repeats a data range based on a frequency column

Repeat.lambda

/* 
Name: REPEAT
Recommended version: v2024 or 365
Description: Repeats a data range based on a frequency column.
    Optimized with Binary Search. 
Made By: Medohh2120
*/

Repeat = LAMBDA(Values,Number_times, 
    LET(
        RunTotal, SCAN(0, Number_times, LAMBDA(acc, nxt, acc + nxt)), //alternative: helper column or SUBTOTAL(9, OFFSET(Number_times, 0, 0, SEQUENCE(ROWS(Number_times)))),
        TotalRows, SUM(Number_times),
        RowMap, XLOOKUP(SEQUENCE(TotalRows), RunTotal, SEQUENCE(ROWS(Values)), , 1, 2),
        CHOOSEROWS(Values, RowMap) //alternative: INDEX(Values, RowMap, SEQUENCE(, COLUMNS(Values)))
    )
);