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