Referencing Queries with Get & Transform: Segmenting, Cleaning and Appending a Messy Dataset

“Reference a Query” is a feature in Excel’s Get and Transform, and it’s not obvious what it does. From the outside it looks the same as Duplicate Query.

This video shows an example of when you’d reference a query and how the feature is used.

Here, we received a dataset that looks like 2 datasets that had been stuck together. They need to be separated, cleansed 2 different ways and then put back together.

“Referencing the Query” allows the user to segment and cleanse the data while remaining connected to the source data in case updates are made.

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My website: https://ozdusoleil.com