Forum Discussion
Solved
How to rearrange data in power query
I have a data sample from excel that is in the following format: Name Column 2 Column 3 Column 4 Column 5 Harry Pig Null Null Null James Apple Pie Cat Tom Ford Ferrari ...
You'll need to create a translation table so you can look up an item and figure out the category (car, pet, designer, food). Then it's a matter of unpivoting; joining; and pivoting to get your desired output.
ronrsnfld
Super User
Super UserYou'll need to create a translation table so you can look up an item and figure out the category (car, pet, designer, food). Then it's a matter of unpivoting; joining; and pivoting to get your desired output.