{"id":3984,"date":"2022-02-04T11:18:34","date_gmt":"2022-02-04T19:18:34","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3984"},"modified":"2022-02-04T11:18:36","modified_gmt":"2022-02-04T19:18:36","slug":"how-to-remove-duplicates-by-using-power-query-for-excel","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3984","title":{"rendered":"How to Remove Duplicates by Using Power Query for Excel"},"content":{"rendered":"\n

<\/p>\n\n\n\n

Open up the Power Query Editor.<\/p>\n\n\n\n

Go to Home > Remove Rows > Remove Duplicates<\/strong><\/em><\/p>\n\n\n\n

\"Excel<\/a><\/figure>\n\n\n\n

STEP 4: <\/strong>Click Close & Load<\/strong> from the Home<\/strong> tab and this will open up a brand new worksheet<\/strong> in your Excel workbook with the cleaned table.<\/p>\n\n\n\n

\"fill-down-10\"<\/a><\/figure>\n\n\n\n

You now have your new table with the remove duplicates power query!<\/p>\n\n\n\n

\"Remove<\/a><\/figure>\n\n\n\n

This completes our tutorial on How to Remove Duplicates in Power Query!<\/p>\n\n\n\n

Here is a video with detailed steps.<\/p>\n\n\n\n

\n