• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Remove Duplicates With Power Query.

Remove Duplicates With Power Query.

October 1, 2020 by Barbara

Hello Excellers. Today I will share with you a great Excel tip. How to remove really quickly duplicate data records using Power Query.

Power Query (previously called Get & Transform) in Excel 2016 is a really easy way to manage your data, and removing duplicate records is one of those easy tasks.

See a sample set of Excel data in the screen grab below.

power query to remove duplicates Pin it! Share on Facebook

Let’s take a look at how easy it is to use Power Query to resolve the duplicate rows of data by following the steps below.


Step 1.  Turn Your Data Into An Excel Table.
Select your data and use the shortcut Ctrl+T or Insert Tab | Tables Group | Table to turn your data into an Excel Table. (my data above is already in table format).


Step 2.  Import Your Data Into Power Query.
Next, in the Data Tab | Get and Transform Group select From Table/Range.

remove duplicates with power query Pin it! Share on Facebook

Step 3. Working In Power Query.
The Power Query editor will automatically open.  On the Home Tab | Reduce Rows Group select the Remove Duplicates option.

remove duplicate records with power power query Pin it! Share on Facebook

Step 4. Loading The Cleansed Data Set.
The final step is to load the cleansed data into Excel.  Once the duplicates have been removed, you can hit the Close & Load option.  This loads your new data set into a new Excel sheet.  Job Done!.

Pin it! Share on Facebook

You now have a new cleansed data set. Easy as that. The duplicates have been removed.

Filed Under: Blog, Excel Business Intelligence, Power Query Tagged With: Excel Tips, Excel Tips& Tricks, excel tutorials

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2023 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Popular Pages

  • Home

More Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Excel Jobs

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Search

Navigation

  • Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • Top Menu

Social

  • Twitter
  • Facebook
© howtoexcelatexcel.com. All rights reserved.
  • Privacy Policy