Forum Discussion

Matt_Paz's avatar
Matt_Paz
Copper Contributor
Jun 18, 2025

Create table using LET based on column values

Hi all Hope you can help. I am trying to create an output table based on another tables column data.   Example: Original Data Table: Task                              Target          Group 1   ...
Formulas and Functions
djclements's avatar
djclements
Bronze Contributor
Jun 22, 2025

Another basic unpivot option:

=LET(
   v, H3:U16,
   t, v<>"",
   λ, LAMBDA(x,TOCOL(IFS(t,x),2)),
   a, INDEX(A3:G16,λ(SEQUENCE(ROWS(v))),{1,2,4,3,6,7}),
   HSTACK(TAKE(a,,4),λ(H2:U2),DROP(a,,4),λ(v))
)

Adjust the 3 range references as needed. See attached...

Resources