Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Unpivot into the one record

Hi,

 

I have attached a sheet with before and after. This is like an unpivot table process but need the details of each student in the one record to do a mail merge.

Thanks Q

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    2 years ago

    NewStep=let col=Table.ColumnNames(Before) in Table.Combine(Table.Group(Before,List.FirstN(col,6),{"n",each #table(List.FirstN(col,6)&List.TransformMany({1..Table.RowCount(_)},each List.Skip(col,6),(x,y)=>y&Text.From(x)),{List.Combine(Table.ToRows(_))})})[n])