Forum Discussion
mterry
1 year agoHelper V
Merging rows and using row values as both column headers and row values
I have a table that has a column filled with questions, and another column with applicable respoonses to those questions. I'm hoping I can transform this table using Power Query so that each question...
- 1 year ago
Just Pivot with no aggregation
Table.Pivot(#"Previous Step", List.Distinct(#"Changed Type"[Question]), "Question", "Response")
ronrsnfld
1 year agoSuper User
Just Pivot with no aggregation
Table.Pivot(#"Previous Step", List.Distinct(#"Changed Type"[Question]), "Question", "Response")