Forum Discussion
Solved
[Excel 365] Positioning a list of values as a "staircase" with dynamic array
Good day dear Excel community I'm scratching my head around a formula I need to write to create the range on the right with a dynamic array. I need to do the following transformation using a ...
It's a rare occasion that MUNIT gets some work.
=LET(r,ROWS(Input),matrix,MUNIT(r)*Input,CHOOSECOLS(matrix,INT(SEQUENCE(r*rep,,MIN(Input),1/rep))))
Assuming that you have Microsoft 365 or use Excel Online:
=LET(n, COUNTA(SourceTable[SourceRange]), MAKEARRAY(n, Repeats*n, LAMBDA(r, c, IF((c>=Repeats*(r-1)+1)*(c<=Repeats*r), INDEX(SourceRange, r),""))))
SourceTable is the table in A2:A6
The data range of this table has been named SourceRange.
Repeats is a named cell that contains the number of times each value should be repeated.
Sample workbook attached.
Thanks Hans, this works quite well!
Really appreciate the help received in such a timely manner.
Really appreciate the help received in such a timely manner.