Forum Discussion

VMelgarejoCaz's avatar
VMelgarejoCaz
Copper Contributor
Jan 20, 2025

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...
Formulas and Functions
Macros and VBA
m_tarler's avatar
m_tarler
Bronze Contributor
Jan 22, 2025

I throw another option into the ring.  I was about to add it when I saw Peter dropped his so I used his workbook and combined all 3 on this workbook.

This option is:

=LET(in, B3:M7, cols, 3,
DROP(REDUCE("",SEQUENCE(ROWS(in)),
   LAMBDA(p,q,HSTACK(p,WRAPROWS(CHOOSEROWS(in,q),cols,0)))),,1))

simply each ROW uses WRAPROWS to create the columns needed and stack to the right.

Resources