Forum Discussion
Community ChampionPower Query Challenge / or good videos recommendations?
There was a good presentation on the London PowerBI world tour. Tristan has a good example of how to clean a file with headers on multiple lines and merged cells: https://youtu.be/uZ3R-2CsHcA?t=18m25s (starts at 16:46 if you want an overview of the data he's using).
The solution is probably a combination of transpose, fill down, merge columns and unpivot.
There was a good presentation on the London PowerBI world tour. Tristan has a good example of how to clean a file with headers on multiple lines and merged cells: https://youtu.be/uZ3R-2CsHcA?t=18m25s (starts at 16:46 if you want an overview of the data he's using).
The solution is probably a combination of transpose, fill down, merge columns and unpivot.
- vanessafvg
am sure there many ways to do it, just want to find the easiest.. will check it out ta
