Remove Duplicates using Power Query in Excel
Like the Remove Duplicates feature in Excel, Power Query also can be used to remove duplicates from a data set. But, why should we use Power Query to get rid of the Duplicates? Here is why . . . Following is a sample sales data containing duplicate records (The records with arrows against them). Now,…