Forum Discussion
Solved
Pivot/Transform Questions
Hello all,
This is how my data look in Power Query, with no changes.
How do I transform the data so it's in this format?
I manually created this table. My actual file has over 7000 rows though, so I can't manually create the whole thing.
e175429 You need this step:
= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Question]), "Question", "Response")
PBIX is attached below sig.
1 Reply
e175429 You need this step:
= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Question]), "Question", "Response")
PBIX is attached below sig.