Daniel Choi solved it using Power Query! Let’s review his solutions. Continue reading
Calculate Hours from Messy Text using Power Query
Post Category → Get & Transform
aggregating text part 2
Haven’t I done this before? It was almost identical except for two details. Continue reading
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
Auditing & Editing M code (Power Query)
Power Query is a powerful and intriguing tool. However, there are stumbling blocks that make it challenging. Let’s audit and then modify some M code! Continue reading
All Combinations Using Power Query
Given 3 separate lists of text how can we create all combinations? I’ve known Power Query (Get & Transform) can create a cartesian product but it’s only now that it’s part of my active skill set. Continue reading
How many unique List 1 names found in List 2?
Imagine two lists of names. We have three questions: (1)how many unique names in List 1? (2)how many unique names in List 2? (3)how many unique names from List 1 are found in List 2? Continue reading
Power Query solution: partial match count with a condition
In a previous post we saw how formulas can solve a partial match with conditions. Now I will solve it using Power Query because my friend Kunle challenged me to do so 🙂 Continue reading
Extract Largest Number (Power Query & Flash Fill solutions)
In a recent post I audited my colleague’s amazing array formula. It extracted the largest number from as420lkjs09nsdk2324lkjsd099 See other solutions suggested by YouTube viewers! Continue reading
Rearranging Data
Rearranging data is initially about recognizing the pattern. This screenshot is from Ken Puls. I instantly saw the steps to rearrange the data (thanks to Ken’s online course!) Continue reading
Normalize Data using Excel Get & Transform
In my last post I used formulas to solve a messy data disaster. In this post/video I’ll show you how to use Excel’s amazing Get & Transform feature (aka Power Query) to re-arrange the data. Continue reading