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, isolate customer details, and use Remove Duplicates to generate a unique client list. You’ll also see how to split full names into first and last, build a separate address dataset, and reuse the same process across multiple files. By the end, you’ll know how to transform repetitive transaction records into structured datasets that integrate smoothly with accounting and reporting systems. 
#PowerQuery #PowerBI #Excel #DataCleaning #DataModeling #BusinessIntelligence #DataAnalytics #ProcessImprovement