Haven’t I done this before? It was almost identical except for two details. Continue reading
aggregating text part 2
Posts Tagged → Power Query
awkward-data/power-query-solution
My last post was about an awkward dataset. Now I’ll review Daniel Choi’s Power Query solution that rearranges the data. Continue reading
Power Query Challenge – What Did They Order from the Menu?
Alan Murray (Computergaga) had an interesting challenge on YouTube. It’s a classic case of “Analyze my awkward dataset!”. He solved it using Power Query. Can it be solved using formulas? Continue reading
Why and How to Unpivot Data
Before you analyze your data it’s important to decide if you need to unpivot it. Why unpivot? What’s unpivot? Are there exceptions? Continue reading
Ken Puls Power Query Challenge #2
In this post I’ll review my solution to Ken Puls’ Power Query challenge #2. Online challenges are fun and it’s a great way to learn from others. Continue reading