Unpivot into the one record

[Syndicate_Admin]

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

[wdx223_Daniel]

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])