Forum Discussion
Transpose in arrays of n columns
Hello all and thanks in adhance for your help. I am tryting to find a formula or shortcut that would allow me to transpose arrays of n columns into matrixes of n rows and n columns, to plot the d...
=LET(cols,3,
rng,B3:M7,
DROP(REDUCE("",SEQUENCE(1,COLUMNS(rng)/cols,1,cols),
LAMBDA(u,v,
VSTACK(u,
TOROW(CHOOSECOLS(rng,SEQUENCE(1,cols,v)))))),
1)
)
This formula works in Office 365 and Excel for the web and returns the intended result in my example. You dynamically change the number of columns in the formula.