Category: Power Query

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

Read More »

Removing Offset Duplicates

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

Read More »

Aggregate Data While Expanding Columns

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

Read More »

Identify Duplicates Using Power Query

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

Read More »

Separate Values and Text – Part 2

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

Read More »

Keep Only Numbers in Power Query

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

Read More »