Open up the Power Query Editor.
Go to Home > Remove Rows > Remove Duplicates
![Remove Duplicates Using Power Query or Get & Transform | MyExcelOnline Excel Power Query Remove Duplicates](https://www.myexcelonline.com/wp-content/uploads/2017/09/Remove-Duplicates-03.png)
STEP 4: Click Close & Load from the Home tab and this will open up a brand new worksheet in your Excel workbook with the cleaned table.
![Remove Duplicates Using Power Query or Get & Transform | MyExcelOnline fill-down-10](https://www.myexcelonline.com/wp-content/uploads/2016/11/Fill-Down-10.png)
You now have your new table with the remove duplicates power query!
![Remove Duplicates Using Power Query or Get & Transform | MyExcelOnline Remove Duplicates with Power Query](https://www.myexcelonline.com/wp-content/uploads/2017/09/Remove-Duplicates-04.png)
This completes our tutorial on How to Remove Duplicates in Power Query!
Here is a video with detailed steps.