fbpx
Email: [email protected] Call Now! +1 203-349-9909 / +91-8080042523

Read How to Remove Duplicates Using Power Query

Power Query cannot only keep duplicate records but also can remove the duplicate data. The advantage of this feature is that it removes the human error whenever you try to delete your duplicate data manually.

Remove Duplicates by Power Query

Suppose you have this set of data. As you can see the marked ones are duplicate values, why not get rid of them!

Step 1: Load the data in Power Query and note the duplicate data

As shown in the below picture, there are few duplicate row items that are highlighted.

DATA TABLE BEFORE REMOVING DUPLICATES

Step 2: Remove Duplicate Rows

To remove the duplicate rows, go to

Home > Remove Rows button > Remove Duplicates option

REMOVE DUPLICATE DATA

Step 3: Save and Close

After you get the expected result, just click on the save icon to save and Close and Apply button to close the Query Editor.

DATA TABLE AFTER REMOVING DUPLICATES

You can learn more :

Leave a Reply