Using Remove Duplicates to Create Data Sets

A woman working on a computer.

Learn how to turn messy order data into clean, usable datasets with Power Query’s Remove Duplicates tool. In this Data Survival Skills session, Robin works with sales from Leaf & Mortar’s pop-up shops, where customer information repeats across every order line. Instead of manually sorting through hundreds of rows, she demonstrates how to duplicate queries,…

Read More