Forum Discussion
Solved
Table transformation
Hi, does anyone have any idea on how to transform this table: To this table: Many thanks, Elad
=LET(filldown,
SCAN("",A2:A15,LAMBDA(ini,arr,IF(ISTEXT(arr),arr,ini))),
HSTACK(
UNIQUE(filldown),
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(UNIQUE(filldown))),LAMBDA(x,y,VSTACK(x,TOROW(FILTER(B2:B15,filldown=INDEX(UNIQUE(filldown),y)))))),1),"")
)
)
With Office 365 or Excel for the web you can apply this formula.
- Thank you! This is amazing!
