Excel 2016 Updates
I was a bit surprised to see some Excel 2016 updates when I opened it up this morning. For reference, I am on an Office 365 early release program – so I might get these a bit before you do
I was a bit surprised to see some Excel 2016 updates when I opened it up this morning. For reference, I am on an Office 365 early release program – so I might get these a bit before you do
This post solves a tricky issue of removing offset duplicates or, in other words, removing items from a list that exist not only in a different column, but also on different rows. Problem History This data format is based on
Without question, the Expand feature that shows up when you are merging tables using Power Query is very useful. But one of the things I’ve never called out is that – when you are merging tables – you have the
Even though this hits on techniques used on this blog before, a colleague asked today “I have a lot of garbage names in a column and only want to keep rows that begin with an alphabetical character.” I figured we’d
As it’s the beginning of a new year, I thought it might be interesting to show my spin on creating a custom calendar in Power Query. This topic has been covered by many others, but I’ve never put my own
Last week’s blog post on merging tables using Outer joins has proved to be pretty popular. (I guess I’m not the only one who struggled with this concept!) This week we’ll look at the remaining three options, showing how to
The term “Join” comes from the database world, and I’ll admit that I’ve struggled with understanding it... especially when you combine it with some other keywords. So this week I thought it would be good to explore it in a
Some time ago I got an email from Alex asking me if there was a way to identify duplicates using Power Query, but without removing non-duplicate records in the process. This post explores how to do that. Background Suppose someone
In this week’s post we’re going to circle back to the original post on how to Separate Values and Text in Power Query from November 4, 2015. That post attracted a couple of suggestions from Imke Feldman and Bill Szysz
My last blog post was interesting in that I got a few emails about it. Both Imke Feldman and Bill Szysz sent me better methods, and a blog commenter asked for a slightly different version. For this post, I’m going
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.