Power QueryExercises

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