{"id":4791,"date":"2024-12-08T09:47:40","date_gmt":"2024-12-08T09:47:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query\/"},"modified":"2024-12-08T09:47:40","modified_gmt":"2024-12-08T09:47:40","slug":"cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query\/","title":{"rendered":"C\u00e1ch g\u1ed9p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng v\u00e0o 1 b\u1ea3ng s\u1eed d\u1ee5ng Power Query"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Vi\u1ec7c t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u tr\u00ean\u00a0Excel ph\u1ee5 thu\u1ed9c r\u1ea5t nhi\u1ec1u y\u1ebfu t\u1ed1:\u00a0\u0111\u1eb7c th\u00f9 c\u1ee7a ngu\u1ed3n nh\u1eadp d\u1eef li\u1ec7u,\u00a0\u0111\u1eb7c th\u00f9 c\u1ee7a d\u1ea1ng d\u1eef li\u1ec7u\u2026 n\u00ean kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng c\u00f3\u00a0\u0111\u01b0\u1ee3c 1 b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00fang\u00a0\u00fd mu\u1ed1n ngay t\u1eeb\u00a0\u0111\u1ea7u. Do\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 ph\u1ee5c v\u1ee5 vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o trong\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n th\u00ec ch\u00fang ta c\u1ea7n ph\u1ea3i t\u1ed5 ch\u1ee9c l\u1ea1i d\u1eef li\u1ec7u. M\u1ed9t trong nh\u1eefng c\u00f4ng vi\u1ec7c th\u01b0\u1eddng g\u1eb7p\u00a0\u0111\u00f3 l\u00e0 g\u1ed9p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng t\u00ednh (c\u00f3 th\u1ec3 tr\u00ean nhi\u1ec1u sheet) v\u00e0o 1 b\u1ea3ng t\u00ednh (tr\u00ean 1 sheet). Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch g\u1ed9p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng v\u00e0o 1 b\u1ea3ng s\u1eed d\u1ee5ng Power Query.<\/p>\n<p>M\u1ee5c ti\u00eau c\u1ee7a ch\u00fang ta nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18411\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/gop-du-lieu-ket-qua.png\" width=\"626\" height=\"690\" title=\"gop-du-lieu-ket-qua\"><\/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-67556b3bc8949\" 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-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html#1_Chuan_bi_du_lieu\" title=\"1. Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u\">1. Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html#2_Nguyen_tac_cua_viec_gop_du_lieu\" title=\"2. Nguy\u00ean t\u1eafc c\u1ee7a vi\u1ec7c g\u1ed9p d\u1eef li\u1ec7u\">2. Nguy\u00ean t\u1eafc c\u1ee7a vi\u1ec7c g\u1ed9p d\u1eef li\u1ec7u<\/a><\/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-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html#3_Cach_thuc_hien_gop_du_lieu_bang_Power_Query\" title=\"3. C\u00e1ch th\u1ef1c hi\u1ec7n g\u1ed9p d\u1eef li\u1ec7u b\u1eb1ng Power Query\">3. C\u00e1ch th\u1ef1c hi\u1ec7n g\u1ed9p d\u1eef li\u1ec7u b\u1eb1ng 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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html#a_Chuyen_cac_bang_can_gop_ve_dang_Table_Data\" title=\"a. Chuy\u1ec3n c\u00e1c b\u1ea3ng c\u1ea7n g\u1ed9p v\u1ec1 d\u1ea1ng Table Data\">a. Chuy\u1ec3n c\u00e1c b\u1ea3ng c\u1ea7n g\u1ed9p v\u1ec1 d\u1ea1ng Table Data<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html#b_Su_dung_Power_Query_ket_noi_cac_bang_Table\" title=\"b. S\u1eed d\u1ee5ng Power Query k\u1ebft n\u1ed1i c\u00e1c b\u1ea3ng Table\">b. S\u1eed d\u1ee5ng Power Query k\u1ebft n\u1ed1i c\u00e1c b\u1ea3ng Table<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html#c_Xuat_du_lieu_tu_Power_Query_ve_1_Sheet_ket_qua\" title=\"c. Xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb Power Query v\u1ec1 1 Sheet k\u1ebft qu\u1ea3\">c. Xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb Power Query v\u1ec1 1 Sheet k\u1ebft qu\u1ea3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Chuan_bi_du_lieu\"><\/span>1. Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file d\u1eef li\u1ec7u g\u1ed1c\u00a0\u0111\u1ec3 th\u1ef1c h\u00e0nh theo b\u00e0i vi\u1ebft t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2JBYRh1\">http:\/\/bit.ly\/2JBYRh1<\/a><\/p>\n<p>Power Query l\u00e0 1 c\u00f4ng c\u1ee5 m\u1edbi c\u00f3 tr\u00ean\u00a0Office t\u1eeb c\u00e1c phi\u00ean b\u1ea3n\u00a0Office 2016,\u00a0Office 365 (\u0111\u00e3 t\u00edch h\u1ee3p s\u1eb5n). N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng\u00a0Office phi\u00ean b\u1ea3n th\u1ea5p h\u01a1n nh\u01b0 2010, 2013 th\u00ec b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i Add-in Power Query tr\u00ean h\u1ec7 th\u1ed1ng c\u1ee7a Microsoft\u00a0Office<\/p>\n<p>Link t\u1ea3i Power Query: <a href=\"https:\/\/www.microsoft.com\/vi-vn\/download\/details.aspx?id=39379\">https:\/\/www.microsoft.com\/vi-vn\/download\/details.aspx?id=39379<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Nguyen_tac_cua_viec_gop_du_lieu\"><\/span>2. Nguy\u00ean t\u1eafc c\u1ee7a vi\u1ec7c g\u1ed9p d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 tr\u00e1nh c\u00e1c l\u1ed7i c\u00f3 th\u1ec3 x\u1ea3y ra trong qu\u00e1 tr\u00ecnh g\u1ed9p d\u1eef li\u1ec7u th\u00ec ch\u00fang ta ph\u1ea3i tu\u00e2n th\u1ee7 m\u1ed9t s\u1ed1 nguy\u00ean t\u1eafc sau:<\/p>\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-392.gif\" title=\"ex101_92019-nho-392\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>D\u1eef li\u1ec7u t\u1eeb c\u00e1c b\u1ea3ng t\u00ednh s\u1ebd\u00a0\u0111\u01b0\u1ee3c n\u1ed1i ti\u1ebfp nhau trong 1 b\u1ea3ng chung<\/li>\n<li>C\u00e1c b\u1ea3ng t\u00ednh ph\u1ea3i c\u00f3 c\u1ea5u tr\u00fac gi\u1ed1ng nhau: s\u1ed1 c\u1ed9t, t\u00ean c\u00e1c c\u1ed9t\u2026\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o nguy\u00ean t\u1eafc n\u1ed1i ti\u1ebfp nhau<\/li>\n<li>C\u00e1c b\u1ea3ng t\u00ednh ph\u1ea3i bao g\u1ed3m d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1 v\u00e0 h\u1ea1n ch\u1ebf d\u00f2ng tr\u1ed1ng xen k\u1ebd d\u1eef li\u1ec7u (\u0111\u1ea3m b\u1ea3o t\u00ednh li\u00ean t\u1ee5c c\u1ee7a d\u1eef li\u1ec7u)<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"3_Cach_thuc_hien_gop_du_lieu_bang_Power_Query\"><\/span>3. C\u00e1ch th\u1ef1c hi\u1ec7n g\u1ed9p d\u1eef li\u1ec7u b\u1eb1ng Power Query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"a_Chuyen_cac_bang_can_gop_ve_dang_Table_Data\"><\/span>a. Chuy\u1ec3n c\u00e1c b\u1ea3ng c\u1ea7n g\u1ed9p v\u1ec1 d\u1ea1ng Table Data<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i m\u1ed7i b\u1ea3ng d\u1eef li\u1ec7u th\u00e0nh ph\u1ea7n ch\u00fang ta s\u1ebd chuy\u1ec3n v\u1ec1 d\u1ea1ng Table data b\u1eb1ng c\u00e1ch:<\/p>\n<ul>\n<li>Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00f3<\/li>\n<li>S\u1eed d\u1ee5ng ph\u00edm t\u1eaft <strong>Ctrl+T<\/strong> (ph\u00edm t\u1eaft c\u1ee7a ch\u1ee9c n\u0103ng\u00a0<strong>Insert\/Table<\/strong>)<\/li>\n<li>X\u00e1c nh\u1eadn vi\u1ec7c chuy\u1ec3n\u00a0\u0111\u1ed5i n\u00e0y<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18413\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/gop-du-lieu-convert-table-data.png\" width=\"982\" height=\"669\" title=\"gop-du-lieu-convert-table-data\"><\/p>\n<p>Sau khi chuy\u1ec3n\u00a0\u0111\u1ed5i ch\u00fang ta s\u1ebd thu\u00a0\u0111\u01b0\u1ee3c 1 Table c\u00f3 t\u00ean l\u00e0 Table1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18415\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/table-name-table1.png\" width=\"619\" height=\"274\" title=\"table-name-table1\"><\/p>\n<p>L\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c b\u1ea3ng kh\u00e1c, ch\u00fang ta s\u1ebd thu\u00a0\u0111\u01b0\u1ee3c 3 table c\u00f3 t\u00ean l\u1ea7n l\u01b0\u1ee3t l\u00e0<\/p>\n<ul>\n<li>Table1 \u2013 C\u1eeda h\u00e0ng A<\/li>\n<li>Table2 \u2013 C\u1eeda h\u00e0ng B<\/li>\n<li>Table3 \u2013 C\u1eeda h\u00e0ng C<\/li>\n<\/ul>\n<p><strong><em>T\u1ea1i sao l\u1ea1i c\u1ea7n chuy\u1ec3n v\u1ec1 d\u1ea1ng Table<\/em><\/strong>? B\u1edfi trong Power Query vi\u1ec7c k\u1ebft n\u1ed1i d\u1eef li\u1ec7u t\u1eeb c\u00e1c Table s\u1ebd d\u1ec5 h\u01a1n, nhanh h\u01a1n. Sau khi k\u1ebft n\u1ed1i c\u00e1c b\u1ea3ng th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 tr\u1ea3 d\u1ea1ng Table v\u1ec1 d\u1ea1ng Range m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, kh\u00f4ng b\u1ecb\u00a0\u1ea3nh h\u01b0\u1edfng g\u00ec.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"b_Su_dung_Power_Query_ket_noi_cac_bang_Table\"><\/span>b. S\u1eed d\u1ee5ng Power Query k\u1ebft n\u1ed1i c\u00e1c b\u1ea3ng Table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong th\u1ebb <strong>Data<\/strong> ch\u00fang ta ch\u1ecdn <strong>From Table\/Range<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18417\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-power-query-from-table.png\" width=\"467\" height=\"157\" title=\"data-power-query-from-table\"><\/p>\n<p>C\u1eeda s\u1ed5 <strong>Power Query<\/strong> s\u1ebd m\u1edf ra. Trong c\u1eeda s\u1ed5 n\u00e0y ch\u00fang ta ch\u1ecdn m\u1ee5c <strong>Append Queries<\/strong> ngay trong th\u1ebb\u00a0<strong>Home<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18419\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-append-queries.png\" width=\"1115\" height=\"273\" title=\"power-query-append-queries\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 Append ch\u00fang ta ch\u1ecdn <strong>Two tables<\/strong> v\u00e0 trong m\u1ee5c <strong>Table to append<\/strong> ch\u1ecdn<strong> Table1 (current)<\/strong>\u00a0 \u2013 c\u00f3 th\u1ec3 l\u00e0 Table kh\u00e1c\u00a0ph\u1ee5 thu\u1ed9c v\u00e0o Table b\u1ea1n ch\u1ecdn khi b\u1ea5m <strong>Data \/ From Table\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18422\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/append-two-tables-from-queries.png\" width=\"876\" height=\"280\" title=\"append-two-tables-from-queries\"><\/p>\n<p>Ti\u1ebfp theo ch\u00fang ta b\u1ea5m v\u00e0o m\u1ee5c <strong>Advanced Editor<\/strong>\u00a0\u0111\u1ec3 s\u1eeda l\u1ea1i c\u00e2u l\u1ec7nh n\u1ed1i d\u1eef li\u1ec7u c\u1ee7a Power Query<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18427\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-editor-advanced-editor.png\" width=\"1255\" height=\"396\" title=\"power-query-editor-advanced-editor\"><\/p>\n<p>Trong c\u00e2u l\u1ec7nh n\u00e0y c\u00e1c b\u1ea1n ch\u00fa\u00a0\u00fd nh\u01b0 sau:<\/p>\n<ul>\n<li>Let \/ Source: l\u00e0 c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u ngu\u1ed3n.\u00a0\u1ede\u00a0\u0111\u00e2y ch\u00fa\u00a0\u00fd Name&#8217;\u201dTable1\u2033 ch\u00ednh l\u00e0 t\u00ean c\u1ee7a c\u00e1c Table\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c t\u1ea1o\u00a0\u1edf tr\u00ean. Ch\u00fang ta s\u1ebd thay\u00a0\u0111\u1ed5i Source n\u00e0y th\u00e0nh 3 Source\u00a0\u1ee9ng v\u1edbi 3 Table<\/li>\n<li>Let\/ Appended: l\u00e0 l\u1ec7nh n\u1ed1i c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u.\u00a0\u0110\u1eb7t c\u00e1c Source v\u00e0o trong c\u00e2u l\u1ec7nh\u00a0= Table.combine({\u2026})<\/li>\n<li>in \/ Appended: tr\u00edch xu\u1ea5t k\u1ebft qu\u1ea3 c\u1ee7a Appended<\/li>\n<li>C\u00e1c l\u1ec7nh kh\u00e1c c\u00f3 th\u1ec3 b\u1ecf qua (v\u00ed d\u1ee5 nh\u01b0 changed type)<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd s\u1eeda l\u1ea1i c\u00e2u l\u1ec7nh tr\u00ean th\u00e0nh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18431\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/edit-source-power-query.png\" width=\"560\" height=\"205\" title=\"edit-source-power-query\"><\/p>\n<p>B\u1ea5m <strong>Done<\/strong> v\u00e0 xem k\u1ebft qu\u1ea3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18432\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-combine-table-query.png\" width=\"1140\" height=\"615\" title=\"ket-qua-combine-table-query\"><\/p>\n<p>Trong m\u1ee5c n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u theo Ng\u00e0y ho\u1eb7c theo C\u1eeda h\u00e0ng t\u00f9y th\u00edch.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"c_Xuat_du_lieu_tu_Power_Query_ve_1_Sheet_ket_qua\"><\/span>c. Xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb Power Query v\u1ec1 1 Sheet k\u1ebft qu\u1ea3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb Power Query v\u1ec1 Sheet th\u00ec ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m v\u00e0o m\u1ee5c <strong>Close &amp; Load<\/strong> trong th\u1ebb <strong>Home<\/strong> v\u00e0 ch\u1ecdn <strong>Close &amp; Load to<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18435\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-editor-close-and-load-01.png\" width=\"190\" height=\"177\" title=\"power-query-editor-close-and-load-01\"><\/p>\n<ul>\n<li>Trong c\u1eeda s\u1ed5 Close &amp; Load to ch\u1ecdn:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\"><strong>Select how you\u00a0want to view this data in your\u00a0workbook<\/strong>: Ch\u1ecdn d\u1ea1ng d\u1eef li\u1ec7u mu\u1ed1n hi\u1ec3n th\u1ecb. Th\u00f4ng th\u01b0\u1eddng c\u00f3 th\u1ec3 ch\u1ecdn Table<\/p>\n<p style=\"padding-left: 60px\"><strong>Where do you\u00a0want to put the data?<\/strong> Ch\u1ecdn n\u01a1i b\u1ea1n mu\u1ed1n\u00a0\u0111\u1eb7t b\u1ea3ng d\u1eef li\u1ec7u k\u1ebft qu\u1ea3 n\u00e0y. N\u1ebfu\u00a0\u0111\u00e3 c\u00f3 v\u1ecb tr\u00ed t\u1ea1i 1 sheet x\u00e1c\u00a0\u0111\u1ecbnh th\u00ec ch\u1ecdn\u00a0Existing\u00a0worksheet, c\u00f2n n\u1ebfu mu\u1ed1n\u00a0\u0111\u01b0a v\u00e0o 1 sheet m\u1edbi th\u00ec ch\u1ecdn New\u00a0worksheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18437\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-import-to.png\" width=\"388\" height=\"353\" title=\"power-query-import-to\"><\/p>\n<p>B\u1ea5m OK\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t thao t\u00e1c v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3.<\/p>\n<p>\u0110\u1ec3 chuy\u1ec3n t\u1eeb d\u1ea1ng Table v\u1ec1 d\u1ea1ng b\u1ea3ng th\u01b0\u1eddng (Range) th\u00ec ch\u00fang ta b\u1ea5m v\u00e0o m\u1ee5c <strong>Convert to range<\/strong> trong th\u1ebb <strong>Table Tools<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18439\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/table-convert-to-range.png\" width=\"933\" height=\"323\" title=\"table-convert-to-range\"><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh\u00a0\u0111\u01b0\u1ee3c thao t\u00e1c gh\u00e9p n\u1ed1i d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng v\u00e0o 1 b\u1ea3ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Power Query r\u1ed3i.\u00a0Vi\u1ec7c gh\u00e9p n\u1ed1i n\u00e0y khi m\u1edbi t\u00ecm hi\u1ec3u c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea1n m\u1ea5t nhi\u1ec1u th\u1eddi gian, nh\u01b0ng v\u1edbi nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, li\u00ean k\u1ebft h\u00e0ng tr\u0103m b\u1ea3ng t\u00ednh v\u00e0o 1 b\u1ea3ng th\u00ec vi\u1ec7c s\u1eed d\u1ee5ng Power Query tr\u1edf n\u00ean r\u1ea5t c\u00f3 hi\u1ec7u qu\u1ea3.<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/macro-gop-du-lieu-nhieu-sheets-excel-vao-1-sheet.html\">c\u00e1ch k\u1ebft n\u1ed1i d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng v\u00e0o 1 b\u1ea3ng s\u1eed d\u1ee5ng VBA<\/a><\/p>\n<p>H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<a href=\"http:\/\/bit.ly\/2JhNEmx\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>\u201c.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel. Chi ti\u1ebft kh\u00f3a h\u1ecdc xem t\u1ea1i:<\/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\/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-392.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4792,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4791","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\/4791","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=4791"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4791\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4792"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}