Forum Discussion
Shaping Dynamic Arrays: Moving beyond Transpose
If you have a triangular table of a certain shape, can it be reshaped so that rows going across become columns going down but with padding at the beginning?
=TRANSPOSE(LET(rng,A1:G6,DROP(IFNA(REDUCE("",SEQUENCE(ROWS(rng)),
LAMBDA(u,v,VSTACK(u,HSTACK(EXPAND("",,v),TOROW(CHOOSEROWS(rng,v),1))))),""),1,1)))With Office 365 or Excel for the web this formula returns the intended result.