Removing Duplicates

[ranjitsingh]

Hi, What is the best way to remove duplicates from the whole table ? Right now it only lets me select 1 column at a time. and remove dupes.. Not sure if this is the correct way of removing 

[lbendlin · Accepted solution]

You can remove duplicate across the entire row by removing the column reference.

Instead of 

= Table.Distinct(#"Expanded footnotes1", {"Column1"})

use

= Table.Distinct(#"Expanded footnotes1")