{"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><\/p>\n\n\n\n<p>Open up the Power Query Editor.<\/p>\n\n\n\n<p>Go to&nbsp;<em><strong>Home &gt; Remove Rows &gt; Remove Duplicates<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.myexcelonline.com\/wp-content\/uploads\/2017\/09\/Remove-Duplicates-03.png\"><img decoding=\"async\" src=\"https:\/\/www.myexcelonline.com\/wp-content\/uploads\/2017\/09\/Remove-Duplicates-03.png\" alt=\"Excel Power Query Remove Duplicates\" class=\"wp-image-6994\" title=\"Remove Duplicates Using Power Query or Get &amp; Transform | MyExcelOnline\"\/><\/a><\/figure>\n\n\n\n<p><strong>STEP 4:&nbsp;<\/strong>Click&nbsp;<strong>Close &amp; Load<\/strong>&nbsp;from the&nbsp;<strong>Home<\/strong>&nbsp;tab and this will&nbsp;<strong>open up a brand new worksheet<\/strong>&nbsp;in your Excel workbook with the cleaned table.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.myexcelonline.com\/wp-content\/uploads\/2016\/11\/Fill-Down-10.png\"><img decoding=\"async\" src=\"https:\/\/www.myexcelonline.com\/wp-content\/uploads\/2016\/11\/Fill-Down-10.png\" alt=\"fill-down-10\" class=\"wp-image-5556\" title=\"Remove Duplicates Using Power Query or Get &amp; Transform | MyExcelOnline\"\/><\/a><\/figure>\n\n\n\n<p>You now have your new table with the remove duplicates power query!<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.myexcelonline.com\/wp-content\/uploads\/2017\/09\/Remove-Duplicates-04.png\"><img decoding=\"async\" src=\"https:\/\/www.myexcelonline.com\/wp-content\/uploads\/2017\/09\/Remove-Duplicates-04.png\" alt=\"Remove Duplicates with Power Query\" class=\"wp-image-6995\" title=\"Remove Duplicates Using Power Query or Get &amp; Transform | MyExcelOnline\"\/><\/a><\/figure>\n\n\n\n<p>This completes our tutorial on How to Remove Duplicates in Power Query!<\/p>\n\n\n\n<p>Here is a video with detailed steps.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How To Remove Duplicates In Excel  With Power Query &amp; Create A Unique List Of Values.\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/m6XoOzGTBMY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Open up the Power Query Editor. Go to&nbsp;Home &gt; Remove Rows &gt; Remove Duplicates STEP 4:&nbsp;Click&nbsp;Close &amp; Load&nbsp;from the&nbsp;Home&nbsp;tab and this will&nbsp;open up a brand new worksheet&nbsp;in your Excel workbook with the cleaned table. You now have your new table with the remove duplicates power query! This completes our tutorial on How to Remove Duplicates <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3984\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[1093,1094,1095],"class_list":["post-3984","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-remove-duplicates-by-using-power-query-for-excel","tag-remove-duplicates-excel","tag-remove-duplicates-power-query"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3984","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3984"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3984\/revisions"}],"predecessor-version":[{"id":3985,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3984\/revisions\/3985"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}