Forum Discussion
Expanding data in a column or row quickly ex: 1,2,3 --> 1,1,1,2,2,2,3,3,3
As the title suggests I need to expand a list of values but not in its current order again, instead adding the same value after it. Doesn't feel that complicated but I don't know how to do it for a ...
- Easier still (same concept): =INDEX(Inputs;INT((SEQUENCE(3*ROWS(Inputs))-1)/3)+1;1)
=MAKEARRAY(3*ROWS(Inputs);1;LAMBDA(I;j;INDEX(Inputs;INT((I-1)/3)+1;1)))
