Forum Discussion
Solved
Transform lines in columns
I havae the following table ID DATE QUESTION ANSWER 123 01/01/2023 name jorge 123 01/01/2023 age 17 123 01/01/2023 gender male 456 01/02/2023 name lara 456 01/0...
=Table.Pivot(YourTable,List.Distinct(YourTable[QUESTION]),"QUESTION","ANSWER",each _{0}?)
=Table.Pivot(YourTable,List.Distinct(YourTable[QUESTION]),"QUESTION","ANSWER",each _{0}?)
Thank you!!!