Deduplicate
Removing duplicate rows, either comparing whole rows or only key columns.
Removing duplicates on key columns keeps the first row for each key, so which row survives depends on order: sort and buffer first if it matters. Duplicates that differ only in spaces or case survive unless you clean the values before deduplicating.
In the Power Query editor
Home → Remove Rows → Remove Duplicates on the selected columns, which writes Table.Distinct.
Learn more
Related functions
Practise it
- beginner~6 minPro
Keep one signup per email address (newsletter)
Build a mailing list with one row per email address from signups that contain repeats.
- advanced~10 minPro
Keep each person's most recent signup (newsletter)
For every email keep only the row with the latest Signed date, whatever the row order.
- beginner~6 minPro
Find invoice numbers that appear more than once (accounts payable)
Before loading, list every invoice number that occurs more than once and how many times.
- intermediate~7 minPro
Count each email once, whatever its case or spacing (petition)
The same address appears as Amara@Mail.example and ' amara@mail.example'. Build a clean list of unique emails.