Unfill in Power Query
Recently I received a question on how to Unfill in Power Query. In other words, we want the opposite of the Fill feature, which fills data into blank cells (cells that contain a null value.) If we see repeating values,
Recently I received a question on how to Unfill in Power Query. In other words, we want the opposite of the Fill feature, which fills data into blank cells (cells that contain a null value.) If we see repeating values,
Removing the top five rows from a data set is easy in Power Query, but what do you do when the number of rows changes? There isn’t a built-in Remove Dynamic Number of Top Rows function. In this post we’ll
On this blog, I showcase a lot of different techniques for manipulating and reshaping data. For anyone that follows the blog, you already know this, and you know it's a pretty important topic to me. But the thing we shouldn't
If you've worked with Power Query in Power BI, you've seen Column Quality and Distribution features already. But I'm super exited to say that I've finally received it in the Insider build of Excel! What are the Column Quality and
Yesterday, Nick (one of our forum users) posted a Phone Words challenge in our forum, which looks like a great candidate for Power Query Challenge #7. I haven't had time to tackle it myself, but if you're up for a
One of the things that I find a bit misunderstood in Power Query is whether or not Data Types matter. I mean, I’m sure everyone agrees to some point that they do, but you do know just how much they
This morning I logged in to check the solutions for Power Query Challenge 6 that were submitted and... Wow! There were a bunch, and some cool variety there. So now it's time to show you all what I came up
Are you ready for Power Query Challenge 6? In this challenge we'll look at splitting nested data sets into a nice table in First Normal Form. Let's take a look at Power Query Challenge 6: Where did the challenge come
I'm super excited that Power Query Intellisense and Highlighting features are finally here in Excel! It's been a long time coming, with these features debuting in Power BI Desktop months ago. Where do Intellisense and Highlighting Show up? Let's look
Ken had a blast in June going down to Atlanta for the Microsoft Business Applications Summit (MBAS). There, he and co-author Miguel Escobar led an in-person workshop together for the first time. Ken also presented a breakout session on best
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
