{"id":3665,"date":"2024-12-03T03:19:12","date_gmt":"2024-12-03T03:19:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-xoa-bo-gia-tri-trung-lap-voi-power-query\/"},"modified":"2024-12-03T03:19:12","modified_gmt":"2024-12-03T03:19:12","slug":"huong-dan-cach-xoa-bo-gia-tri-trung-lap-voi-power-query","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-xoa-bo-gia-tri-trung-lap-voi-power-query\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch xo\u00e1 b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u1edbi Power Query"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a>\u00a0<\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch xo\u00e1 b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p b\u1eb1ng c\u00e1ch d\u00f9ng Power Query r\u1ea5t\u00a0 nhanh ch\u00f3ng, v\u1edbi ch\u1ee9c n\u0103ng Remove Duplicates trong Power Query Editor<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674e78afc8b5a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-xoa-bo-gia-tri-trung-lap-voi-power-query.html#Cach_xoa_bo_gia_tri_trung_lap_voi_Power_Query\" title=\"C\u00e1ch xo\u00e1 b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u1edbi Power Query\">C\u00e1ch xo\u00e1 b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u1edbi Power Query<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-xoa-bo-gia-tri-trung-lap-voi-power-query.html#Dua_du_lieu_vao_Power_Query_Editor\" title=\"\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o Power Query Editor\">\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o Power Query Editor<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-xoa-bo-gia-tri-trung-lap-voi-power-query.html#Cach_loai_bo_gia_tri_trung_lap_voi_Power_Query\" title=\"C\u00e1ch lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u1edbi Power Query\">C\u00e1ch lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u1edbi Power Query<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_xoa_bo_gia_tri_trung_lap_voi_Power_Query\"><\/span>C\u00e1ch xo\u00e1 b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u1edbi Power Query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>\n<\/h3>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Dua_du_lieu_vao_Power_Query_Editor\"><\/span>\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o Power Query Editor<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 ti\u1ebfn h\u00e0nh th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c trong c\u1eeda s\u1ed5 Power Query Editor th\u00ec tr\u01b0\u1edbc h\u1ebft ta c\u1ea7n \u0111\u01b0a d\u1eef li\u1ec7u t\u1eeb Excel v\u00e0o trong Power Query Editor. \u0110i\u1ec1u n\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n, c\u1ee5 th\u1ec3 ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>\u1ede \u0111\u00e2y m\u00ecnh d\u00f9ng Excel 365 n\u00ean ch\u1ee9c n\u0103ng Power Query n\u1eb1m \u1edf trong Tabl Data tr\u00ean thanh Ribbon c\u1ee7a Excel (n\u1ebfu b\u1ea1n d\u00f9ng c\u00e1c b\u1ea3n Excel kh\u00e1c th\u00ec c\u00e1ch d\u00f9ng Power Query n\u00e0y c\u00f3 th\u1ec3 \u1edf h\u01a1i kh\u00e1c)<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-32939\" src=\"https:\/\/blog.gitiho.com\/wp-content\/uploads\/2019\/12\/1-17.png\" alt=\"cach-dung-power-query-1\" width=\"722\" height=\"567\"><\/figure>\n<p>Tham kh\u1ea3o th\u00eam v\u1ec1 c\u00e1ch c\u00e0i Power Query trong Excel<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ccach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-excel.html\"><strong><em>h\u01b0\u1edbng d\u1eabn c\u00e1ch k\u1ebft n\u1ed1i t\u1edbi sql sever \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u v\u00e0o excel<\/em><\/strong><\/a><\/p>\n<p>T\u1ea1i Power Query b\u1ea1n t\u00ecm t\u1edbi From Table\/Range \u0111\u1ec3 ti\u1ebfn h\u00e0nh nh\u1eadp d\u1eef li\u1ec7u t\u1eeb 1 Table ho\u1eb7c 1 v\u00f9ng (range) v\u00e0o Power Query Editor \u0111\u1ec3 x\u1eed l\u00fd. D\u1eef li\u1ec7u m\u00ecnh l\u1ea5y l\u00e0m v\u00ed d\u1ee5 cho b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p n\u00e0y nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u1edf tr\u00ean (danh s\u00e1ch h\u00e0ng ho\u00e1 v\u1edbi c\u00e1c lo\u1ea1i hoa qu\u1ea3), ta s\u1ebd lo\u1ea1i b\u1ecf nh\u1eefng lo\u1ea1i hoa qu\u1ea3 tr\u00f9ng l\u1eb7p n\u00e0y nh\u01b0 sau.<\/p>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_loai_bo_gia_tri_trung_lap_voi_Power_Query\"><\/span>C\u00e1ch lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u1edbi Power Query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi \u0111\u00e3 \u0111\u01b0a d\u1eef li\u1ec7u v\u00e0o Power Query Editor, d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n tr\u00f4ng s\u1ebd nh\u01b0 sau trong c\u1eeda s\u1ed5 Power Query Editor<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-121.gif\" title=\"vba101_92019-nho-121\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-283.gif\" title=\"ex101_92019-nho-283\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-32940\" src=\"https:\/\/blog.gitiho.com\/wp-content\/uploads\/2019\/12\/2-14-1024x310.png\" alt=\"cach-dung-power-query-2\" width=\"1024\" height=\"310\"><\/figure>\n<p>Vi\u1ec7c lo\u1ea1i b\u1ecf tr\u00f9ng l\u1eb7p trong n\u00e0y r\u1ea5t \u0111\u01a1n gi\u1ea3n, b\u1ea1n th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p>B\u1ea1n ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, t\u1ea1i Tab Home b\u1ea1n t\u00ecm t\u1edbi nh\u00f3m Reduce Rows, t\u1ea1i \u0111\u00e2y, b\u1ea1n ch\u1ecdn Remove Rows.<\/p>\n<p>B\u1ea1n ch\u1ecdn Remove Duplicates \u0111\u1ec3 th\u1ef1c hi\u1ec7n xo\u00e1 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p. Ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sau<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-32941\" src=\"https:\/\/blog.gitiho.com\/wp-content\/uploads\/2019\/12\/3-11-1024x208.png\" alt=\"cach-dung-power-query-3\" width=\"1024\" height=\"208\"><\/figure>\n<p>T\u1ea1i Applied Steps b\u1ea1n s\u1ebd th\u1ea5y 1 b\u01b0\u1edbc \u0111\u01b0\u1ee3c Power Query Editor ghi l\u1ea1i cho thao t\u00e1c xo\u00e1 tr\u00f9ng b\u1ea1n v\u1eeba th\u1ef1c hi\u1ec7n tr\u1edf tr\u00ean.<\/p>\n<p>B\u00e2y gi\u1edd b\u1ea1n ch\u1ec9 c\u1ea7n xu\u1ea5t k\u1ebft qu\u1ea3 \u0111\u00f3 v\u00e0o Excel, l\u00fac n\u00e0y ta c\u00f3 k\u1ebft qu\u1ea3<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-32942\" src=\"https:\/\/blog.gitiho.com\/wp-content\/uploads\/2019\/12\/4-3-1024x242.png\" alt=\"cach-dung-power-query-4\" width=\"1024\" height=\"242\"><\/figure>\n<p>Ch\u1ec9 \u0111\u01a1n gi\u1ea3n nh\u01b0 v\u1eady th\u00f4i l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh xong vi\u1ec7c lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u1edbi Power Query r\u1ed3i. Gi\u1edd \u0111\u00e2y, m\u1ed7i l\u1ea7n b\u1ea1n th\u1ef1c hi\u1ec7n th\u00eam d\u1eef li\u1ec7u v\u00e0o Data g\u1ed1c ban \u0111\u1ea7u, b\u1ea1n ch\u1ec9 c\u1ea7n Refresh l\u1ea1i b\u1ea3ng k\u1ebft qu\u1ea3 n\u00e0y th\u00ec ngay l\u1eadp t\u1ee9c Power Query s\u1ebd th\u1ef1c hi\u1ec7n lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c cho b\u1ea1n.<\/p>\n<p>V\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/power-query-la-gi-tai-sao-can-hoc-power-query.html\"><strong>Power Query<\/strong><\/a> b\u1ea1n s\u1ebd l\u00e0m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u \u0111i\u1ec1u th\u00fa v\u1ecb kh\u00e1c, tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c ngay d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a <strong>H\u1ecdc Excel Online <\/strong>\u0111\u1ec3 hi\u1ec3u th\u00eam c\u00e1ch d\u00f9ng power query .\u00a0<\/p>\n<hr class=\"wp-block-separator\">\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ccach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-excel.html\"><strong><em data-rich-text-format-boundary=\"true\">h\u01b0\u1edbng d\u1eabn c\u00e1ch k\u1ebft n\u1ed1i t\u1edbi sql sever \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u v\u00e0o excel<\/em><\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/vo-hieu-hoa-chuc-nang-tu-phat-hien-kieu-du-lieu-trong-power-query-editor.html\"><em><strong>v\u00f4 hi\u1ec7u ho\u00e1 ch\u1ee9c n\u0103ng t\u1ef1 ph\u00e1t hi\u1ec7n ki\u1ec3u d\u1eef li\u1ec7u trong power query editor<\/strong><\/em><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-power-bi.html\"><em><strong>h\u01b0\u1edbng d\u1eabn c\u00e1ch k\u1ebft n\u1ed1i t\u1edbi sql sever \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u v\u00e0o power bi<\/strong><\/em><\/a><\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-121.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3666,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3665","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3665"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3665\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3666"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}