Forum Discussion
Solved
Data table row to column with multiple columns
Hi guys, I have a data table in the following format. I need your help to group by the fields: 1, 3, 4, and 5, and finally, pivot the -fieldName- and -valueResult- columns. I have tried pivot and ...
NewStep=Table.Pivot(PreviousStepName,List.Distinct(PreviousStepName[fieldName]),"fieldName","valueResult",each _{0}?)
NewStep=Table.Pivot(PreviousStepName,List.Distinct(PreviousStepName[fieldName]),"fieldName","valueResult",each _{0}?)