{"id":3132,"date":"2024-12-02T23:36:35","date_gmt":"2024-12-02T23:36:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-bo-sao-luu-du-lieu-trong-mot-cot\/"},"modified":"2024-12-02T23:36:35","modified_gmt":"2024-12-02T23:36:35","slug":"power-query-bo-sao-luu-du-lieu-trong-mot-cot","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-bo-sao-luu-du-lieu-trong-mot-cot\/","title":{"rendered":"Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-h4k0Fa0I#1\">\n<p><em><span style=\"font-weight: 400\">Ch\u1eafc h\u1eb3n b\u1ea1n c\u0169ng \u0111\u00e3 c\u00f3 m\u1ed9t l\u1ea7n v\u01b0\u1edbng m\u1eafc v\u00ec\u00a0 ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u kh\u00e1 ph\u1ed5 bi\u1ebfn v\u00e0 kh\u00f3 ch\u1ecbu trong Power Query l\u00e0 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c x\u1ebfp ch\u1ed3ng l\u00ean nhau trong m\u1ed9t c\u1ed9t. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p c\u01a1 b\u1ea3n \u0111\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/power-query-bo-sao-luu-du-lieu-trong-mot-cot.html\"><strong>b\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/strong>.<\/a>\u00a0<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">M\u1eb7c d\u00f9 v\u00ed d\u1ee5 m\u00e0 ch\u00fang ta \u0111ang xem x\u00e9t b\u00ean d\u01b0\u1edbi r\u1ea5t c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u1ea1o ra b\u1edfi m\u1ed9t ng\u01b0\u1eddi kh\u00f4ng bi\u1ebft c\u00e1ch c\u1ea5u tr\u00fac d\u1eef li\u1ec7u ch\u00ednh x\u00e1c, nh\u01b0ng \u0111\u1ecbnh d\u1ea1ng n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y nh\u01b0 nhau trong d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c xu\u1ea5t ho\u1eb7c sao ch\u00e9p t\u1eeb h\u1ec7 th\u1ed1ng IT (m\u1eb7c d\u00f9 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c xu\u1ea5t ho\u1eb7c sao ch\u00e9p c\u00f3 xu h\u01b0\u1edbng th\u00e0nh m\u1ed9t c\u1ed9t duy nh\u1ea5t, d\u1ec5 x\u1eed l\u00fd h\u01a1n m\u1ed9t ch\u00fat).<\/span><\/p>\n<figure id=\"attachment_34617\" aria-describedby=\"caption-attachment-34617\" style=\"width: 506px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34617 size-full\" title=\"1 - Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-6.png\" alt=\"1 - Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"506\" height=\"603\"><figcaption id=\"caption-attachment-34617\" class=\"wp-caption-text\">1 \u2013 Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi cho th\u1ea5y \u0111\u1ecba ch\u1ec9 (address) c\u00f3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c x\u1ebfp ch\u1ed3ng l\u00ean nhau trong m\u1ed9t c\u1ed9t<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 t\u01b0\u1edfng t\u01b0\u1ee3ng, thao t\u00e1c d\u1eef li\u1ec7u \u1edf trong b\u1ed1 c\u1ee5c n\u00e0y \u0111\u1eb7c bi\u1ec7t kh\u00f3 kh\u0103n. \u0110\u1ec3 l\u00e0m cho n\u00f3 c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c, m\u1ed7i h\u00e0ng c\u1ee7a <\/span><b>Address<\/b><span style=\"font-weight: 400\"> ph\u1ea3i l\u00e0 m\u1ed9t c\u1ed9t ri\u00eang bi\u1ec7t. \u0110\u00e2y l\u00e0 l\u00fac c\u1ea7n <a href=\"http:\/\/blog.ezworkapp.com\/power-query-la-gi-tai-sao-can-hoc-power-query.html\"><strong>Power Query<\/strong><\/a> \u0111\u1ebfn gi\u1ea3i c\u1ee9u m\u1ed9t l\u1ea7n n\u1eefa.<\/span><\/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-674e4482c9ec2\" 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\/power-query-bo-sao-luu-du-lieu-trong-mot-cot.html#Tai_xuong_tep_vi_du\" title=\"T\u1ea3i xu\u1ed1ng t\u1ec7p v\u00ed d\u1ee5\">T\u1ea3i xu\u1ed1ng t\u1ec7p v\u00ed d\u1ee5<\/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\/power-query-bo-sao-luu-du-lieu-trong-mot-cot.html#Bo_sao_luu_du_lieu_mot_cot\" title=\"B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u m\u1ed9t c\u1ed9t\">B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u m\u1ed9t c\u1ed9t<\/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\/power-query-bo-sao-luu-du-lieu-trong-mot-cot.html#Don_dep_cac_du_lieu_duoc_nhap\" title=\"D\u1ecdn d\u1eb9p c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp\">D\u1ecdn d\u1eb9p c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/power-query-bo-sao-luu-du-lieu-trong-mot-cot.html#Them_cot_Index_va_Modulo\" title=\"Th\u00eam c\u1ed9t Index v\u00e0 Modulo\">Th\u00eam c\u1ed9t Index v\u00e0 Modulo<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/power-query-bo-sao-luu-du-lieu-trong-mot-cot.html#Ket_thuc_viec_bo_sao_luu_du_lieu\" title=\"K\u1ebft th\u00fac vi\u1ec7c b\u1ecf sao l\u01b0u d\u1eef li\u1ec7u.\u00a0\">K\u1ebft th\u00fac vi\u1ec7c b\u1ecf sao l\u01b0u d\u1eef li\u1ec7u.\u00a0<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tai_xuong_tep_vi_du\"><\/span><b>T\u1ea3i xu\u1ed1ng t\u1ec7p v\u00ed d\u1ee5<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 l\u00e0m vi\u1ec7c c\u00f9ng v\u1edbi c\u00e1c v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi, h\u00e3y t\u1ea3i xu\u1ed1ng t\u1ec7p m\u1eabu. <a href=\"https:\/\/drive.google.com\/file\/d\/1LkCuZ2XkFnOSKgtqYR4y3VllpSn1XSlf\/view\"><strong>Nh\u1ea5p v\u00e0o \u0111\u00e2y <\/strong><\/a>\u0111\u1ec3 \u0111\u0103ng k\u00fd v\u00e0 c\u00f3 quy\u1ec1n truy c\u1eadp v\u00e0o ph\u1ea7n T\u1ea3i xu\u1ed1ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 b\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong b\u00e0i vi\u1ebft n\u00e0y s\u1eed d\u1ee5ng <\/span><b>Example 13 \u2013 Unstack data.xlsx\u00a0<\/b><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bo_sao_luu_du_lieu_mot_cot\"><\/span><b>B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u m\u1ed9t c\u1ed9t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">M\u1edf trang t\u00ednh V\u00ed d\u1ee5 1 t\u1eeb t\u1ec7p \u0111\u00e3 t\u1ea3i xu\u1ed1ng. D\u1eef li\u1ec7u s\u1ebd tr\u00f4ng gi\u1ed1ng nh\u01b0 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh m\u00e0 ch\u00fang ta \u0111\u00e3 th\u1ea5y \u1edf tr\u00ean.<\/span><\/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-237.gif\" title=\"ex101_92019-nho-237\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">D\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 \u1edf \u0111\u1ecbnh d\u1ea1ng B\u1ea3ng(Table) m\u00e0 m\u00ecnh \u0111\u00e3 \u0111\u1eb7t t\u00ean l\u00e0 <\/span><i><span style=\"font-weight: 400\">Customers<\/span><\/i><span style=\"font-weight: 400\">. \u0110\u1ec3 nh\u1eadp d\u1eef li\u1ec7u v\u00e0o Power Query, h\u00e3y ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong B\u1ea3ng v\u00e0 nh\u1ea5p v\u00e0o <\/span><b>Data -&gt; From Table\/Range<\/b><\/p>\n<p><span style=\"font-weight: 400\">C\u1eeda s\u1ed5 Power Query s\u1ebd m\u1edf ra v\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u, tr\u00f4ng gi\u1ed1ng nh\u01b0 m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_34618\" aria-describedby=\"caption-attachment-34618\" style=\"width: 450px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34618 size-full\" title=\"2 - Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-5.png\" alt=\"2 - Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"450\" height=\"356\"><figcaption id=\"caption-attachment-34618\" class=\"wp-caption-text\">2 \u2013 Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Don_dep_cac_du_lieu_duoc_nhap\"><\/span><b>D\u1ecdn d\u1eb9p c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd ch\u00fang ta h\u00e3y t\u00e1ch c\u00e1c d\u00f2ng \u0111\u1ecba ch\u1ec9 ri\u00eang bi\u1ec7t th\u00e0nh c\u00e1c c\u1ed9t. Tr\u01b0\u1edbc ti\u00ean, h\u00e3y x\u00f3a b\u1ea5t k\u1ef3 h\u00e0ng tr\u1ed1ng n\u00e0o b\u1eb1ng c\u00e1ch l\u1ecdc c\u1ed9t <\/span><b>Address<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb r\u1ed7ng(null)<\/span><\/p>\n<figure id=\"attachment_34619\" aria-describedby=\"caption-attachment-34619\" style=\"width: 677px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34619 size-full\" title=\"3- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-5.png\" alt=\"3- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"677\" height=\"561\"><figcaption id=\"caption-attachment-34619\" class=\"wp-caption-text\">3- Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o c\u1ed9t <\/span><i><span style=\"font-weight: 400\">Customer<\/span><\/i><span style=\"font-weight: 400\">, sau \u0111\u00f3 nh\u1ea5p v\u00e0o <\/span><b>Transform -&gt; Fill (dropdown) -&gt; Down<\/b><span style=\"font-weight: 400\">. \u0110i\u1ec1u n\u00e0y s\u1ebd \u0111\u1ea3m b\u1ea3o m\u1ed7i h\u00e0ng s\u1ebd c\u00f3 t\u00ean kh\u00e1ch h\u00e0ng trong \u0111\u00f3, kh\u00f4ng \u0111\u01b0\u1ee3c c\u00f3 b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb r\u1ed7ng n\u00e0o trong c\u1ed9t <\/span><i><span style=\"font-weight: 400\">Customer.<\/span><\/i><\/p>\n<figure id=\"attachment_34620\" aria-describedby=\"caption-attachment-34620\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34620 size-full\" title=\"4- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h4-6.png\" alt=\"4- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"750\" height=\"137\"><figcaption id=\"caption-attachment-34620\" class=\"wp-caption-text\">4- Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Them_cot_Index_va_Modulo\"><\/span><b>Th\u00eam c\u1ed9t <\/b><b>Index<\/b><b> v\u00e0 Modulo<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong v\u00e0i l\u1ea7n bi\u1ebfn \u0111\u1ed5i ti\u1ebfp theo n\u00e0y, m\u1ecdi th\u1ee9 b\u1eaft \u0111\u1ea7u c\u00f3 v\u1ebb h\u01a1i k\u1ef3 qu\u1eb7c. Tuy nhi\u00ean b\u1ea1n c\u1ee9 l\u00e0m theo h\u01b0\u1edbng d\u1eabn c\u1ee7a m\u00ecnh, \u0111\u1ebfn cu\u1ed1i c\u00f9ng m\u1ecdi th\u1ee9 s\u1ebd ho\u00e0n t\u1ea5t v\u00e0 b\u1ea1n s\u1ebd hi\u1ec3u. Tin m\u00ecnh \u0111i!<\/span><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html\">Chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u v\u1edbi power Query<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 3 h\u00e0ng cho m\u1ecdi \u0111\u1ecba ch\u1ec9 kh\u00e1ch h\u00e0ng. C\u00e1c ph\u00e9p bi\u1ebfn \u0111\u1ed5i ti\u1ebfp theo c\u1ee7a ch\u00fang ta l\u00e0 bao g\u1ed3m m\u1ed9t c\u1ed9t s\u1ed1 hi\u1ec3n th\u1ecb c\u00e1c s\u1ed1 0, 1 v\u00e0 2 l\u1eb7p \u0111i l\u1eb7p l\u1ea1i. 0 s\u1ebd \u0111\u1ea1i di\u1ec7n cho d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a \u0111\u1ecba ch\u1ec9, 1 d\u00f2ng th\u1ee9 hai c\u1ee7a \u0111\u1ecba ch\u1ec9 v\u00e0 2 l\u00e0 d\u00f2ng cu\u1ed1i c\u00f9ng c\u1ee7a \u0111\u1ecba ch\u1ec9.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o <\/span><span style=\"font-weight: 400\">\u00a0<\/span><b>Add Column -&gt; Index Column<\/b><\/p>\n<figure id=\"attachment_34621\" aria-describedby=\"caption-attachment-34621\" style=\"width: 794px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34621 size-full\" title=\"5- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h5-6.png\" alt=\"5- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"794\" height=\"325\"><figcaption id=\"caption-attachment-34621\" class=\"wp-caption-text\">5- Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">M\u1ed9t c\u1ed9t ch\u1ec9 m\u1ee5c \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o, b\u1eaft \u0111\u1ea7u t\u1eeb 0.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn c\u1ed9t index m\u1edbi n\u00e0y, sau \u0111\u00f3 nh\u1ea5p v\u00e0o <\/span><b>Add Column -&gt; Standard -&gt; Modulo<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<figure id=\"attachment_34622\" aria-describedby=\"caption-attachment-34622\" style=\"width: 789px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34622 size-full\" title=\"6- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h6-6.png\" alt=\"6- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"789\" height=\"250\"><figcaption id=\"caption-attachment-34622\" class=\"wp-caption-text\">6- Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u1eadp 3 v\u00e0o c\u1eeda s\u1ed5 Modulo, v\u00ec c\u00f3 3 h\u00e0ng trong m\u1ed7i \u0111\u1ecba ch\u1ec9. B\u1ea5m OK.<\/span><\/p>\n<figure id=\"attachment_34623\" aria-describedby=\"caption-attachment-34623\" style=\"width: 675px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34623 size-full\" title=\"7- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h7-5.png\" alt=\"7- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"675\" height=\"259\"><figcaption id=\"caption-attachment-34623\" class=\"wp-caption-text\">7- Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111\u00e3 l\u00e0m theo t\u1ea5t c\u1ea3 c\u00e1c b\u01b0\u1edbc tr\u00ean th\u00ec C\u1eeda s\u1ed5 xem tr\u01b0\u1edbc s\u1ebd gi\u1ed1ng nh\u01b0 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn c\u1ed9t Modulo m\u00e0 ch\u00fang ta \u0111\u00e3 t\u1ea1o. Nh\u1ea5p v\u00e0o <\/span><b>Transform -&gt; Pivot Column<\/b><span style=\"font-weight: 400\">.<\/span><span style=\"font-weight: 400\">. Trong c\u1eeda s\u1ed5 <\/span><span style=\"font-weight: 400\">Pivot Column<\/span><span style=\"font-weight: 400\">, ch\u1ecdn c\u1ed9t <\/span><b>Address<\/b><span style=\"font-weight: 400\">, m\u1edf r\u1ed9ng c\u00e1c t\u00f9y ch\u1ecdn n\u00e2ng cao v\u00e0 ch\u1ecdn <\/span><b>Don\u2019t Aggregate<\/b><span style=\"font-weight: 400\">, sau \u0111\u00f3 nh\u1ea5p v\u00e0o OK.<\/span><\/p>\n<figure id=\"attachment_34624\" aria-describedby=\"caption-attachment-34624\" style=\"width: 791px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34624 size-full\" title=\"8- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h8-5.png\" alt=\"8- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"791\" height=\"357\"><figcaption id=\"caption-attachment-34624\" class=\"wp-caption-text\">8- Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">H\u00e3y nh\u00ecn v\u00e0o c\u1eeda s\u1ed5 xem tr\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 ngh\u0129 r\u1eb1ng ch\u00fang ta \u0111ang l\u00e0m r\u1ed1i tung m\u1ecdi th\u1ee9, c\u1ee9 b\u00ecnh t\u0129nh, t\u1ea5t c\u1ea3 \u0111\u1ec1u ch\u1ec9 l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a qu\u00e1 tr\u00ecnh. Ti\u1ebfp t\u1ee5c th\u00f4i n\u00e0o.<\/span><\/p>\n<figure id=\"attachment_34625\" aria-describedby=\"caption-attachment-34625\" style=\"width: 739px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34625 size-full\" title=\"9- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h9-4.png\" alt=\"9- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"739\" height=\"279\"><figcaption id=\"caption-attachment-34625\" class=\"wp-caption-text\">9- Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn c\u00e1c c\u1ed9t c\u00f3 ti\u00eau \u0111\u1ec1 1 v\u00e0 2, sau \u0111\u00f3 \u00e1p d\u1ee5ng ph\u00e9p bi\u1ebfn \u0111\u1ed5i <\/span><span style=\"font-weight: 400\">\u00a0<\/span><b>Transform -&gt; Fill Down<\/b><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn c\u1ed9t 0 v\u00e0 b\u1ed9 l\u1ecdc \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb r\u1ed7ng. Gi\u1edd \u0111\u00e2y, C\u1eeda s\u1ed5 Xem tr\u01b0\u1edbc s\u1ebd hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u \u1edf \u0111\u1ecbnh d\u1ea1ng sau:<\/span><\/p>\n<figure id=\"attachment_34626\" aria-describedby=\"caption-attachment-34626\" style=\"width: 742px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34626 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h10-4.png\" alt=\"10- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"742\" height=\"220\" title=\"h10-4\"><figcaption id=\"caption-attachment-34626\" class=\"wp-caption-text\">10- Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u1ee6a ph\u00e9p thu\u1eadt h\u1ea3? T\u1eeb m\u1ed9t t\u1eadp d\u1eef li\u1ec7u b\u1eeba b\u1ed9n sang m\u1ed9t t\u1eadp d\u1eef li\u1ec7u \u0111\u1eb9p v\u00e0 g\u1ecdn g\u00e0ng ch\u1ec9 trong m\u1ed9t v\u00e0i ph\u00e9p bi\u1ebfn \u0111\u1ed5i c\u01a1 b\u1ea3n :))<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u1ed9t trong nh\u1eefng k\u1ef9 n\u0103ng quan tr\u1ecdng \u0111\u1ed1i v\u1edbi Power Query l\u00e0 kh\u1ea3 n\u0103ng th\u1ef1c hi\u1ec7n nhi\u1ec1u bi\u1ebfn \u0111\u1ed5i nh\u1ecf m\u00e0 cu\u1ed1i c\u00f9ng vi\u1ec7c b\u1ed5 sung s\u1ebd \u0111\u01b0a d\u1eef li\u1ec7u v\u00e0o \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng. Th\u00f4ng th\u01b0\u1eddng, m\u1ed9t c\u00e1i g\u00ec \u0111\u00f3 c\u00f3 v\u1ebb gi\u1ed1ng nh\u01b0 m\u1ed9t s\u1ef1 bi\u1ebfn \u0111\u1ed5i nh\u1ecf, ch\u1eb3ng h\u1ea1n nh\u01b0 vi\u1ec7c gi\u1ea3i n\u00e9n d\u1eef li\u1ec7u, c\u00f3 th\u1ec3 y\u00eau c\u1ea7u nhi\u1ec1u b\u01b0\u1edbc nh\u1ecf h\u01a1n.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_thuc_viec_bo_sao_luu_du_lieu\"><\/span><b>K\u1ebft th\u00fac vi\u1ec7c b\u1ecf sao l\u01b0u d\u1eef li\u1ec7u.\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 bi\u1ebfn \u0111\u1ed5i \u0111\u01a1n gi\u1ea3n c\u00f2n l\u1ea1i \u0111\u1ec3 thu g\u1ecdn m\u1ecdi th\u1ee9:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Lo\u1ea1i b\u1ecf c\u1ed9t ch\u1ec9 m\u1ee5c (Ch\u1ecdn c\u1ed9t v\u00e0 nh\u1ea5p v\u00e0o <\/span><b>Home -&gt; Remove Columns<\/b><span style=\"font-weight: 400\">)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ed5i t\u00ean c\u00e1c c\u1ed9t 0, 1 v\u00e0 2 (b\u1ea5m \u0111\u00fap v\u00e0o t\u1eebng ti\u00eau \u0111\u1ec1 c\u1ed9t v\u00e0 \u0111\u1eb7t t\u00ean c\u00f3 \u00fd ngh\u0129a).<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">D\u1eef li\u1ec7u hi\u1ec7n \u0111\u00e3 s\u1eb5n s\u00e0ng. Nh\u1ea5p v\u00e0o <\/span><b>Close and Load<\/b> <span style=\"font-weight: 400\">\u00a0\u0111\u1ec3 \u0111\u1ea9y d\u1eef li\u1ec7u v\u00e0o Excel.<\/span><\/p>\n<figure id=\"attachment_34627\" aria-describedby=\"caption-attachment-34627\" style=\"width: 616px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34627 size-full\" title=\"11- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h11-3.png\" alt=\"11- Power Query - B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t\" width=\"616\" height=\"227\"><figcaption id=\"caption-attachment-34627\" class=\"wp-caption-text\">11- Power Query \u2013 B\u1ecf sao l\u01b0u d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta \u0111\u00e3 th\u1ea5y c\u00e1ch t\u00e1ch m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u. Nh\u01b0ng quan tr\u1ecdng h\u01a1n, ch\u00fang ta \u0111\u00e3 th\u1ea5y r\u1eb1ng nh\u1eefng k\u1ebft qu\u1ea3 c\u00f3 v\u1ebb c\u01a1 b\u1ea3n nh\u01b0ng l\u1ea1i kh\u00e1 ph\u1ee9c t\u1ea1p. Hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1c ph\u00e9p bi\u1ebfn \u0111\u1ed5i \u0111\u01a1n gi\u1ea3n v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p ch\u00fang v\u1edbi nhau kh\u00f4ng ph\u1ea3i d\u1ec5 d\u00e0ng, b\u1ea1n c\u1ea7n th\u1eddi gian nghi\u00ean c\u1ee9u th\u1eadt k\u1ef9 v\u00e0 th\u1ef1c h\u00e0nh.<\/span><\/p>\n<p><em><span style=\"font-weight: 400\">Ngo\u00e0i ra v\u1eabn c\u00f3 nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c \u0111\u1ec3 <strong>b\u1ecf sao l\u01b0u d\u1eef li\u1ec7u<\/strong>, \u00edt b\u01b0\u1edbc h\u01a1n nh\u01b0ng l\u1ea1i kh\u00e1 ph\u1ee9c t\u1ea1p \u0111\u1ec3 hi\u1ec3u \u0111\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi kh\u00f4ng chuy\u00ean v\u1ec1 Excel. H\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n trong nh\u1eefng b\u00e0i vi\u1ebft t\u1edbi c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong> nh\u00e9!<\/span><\/em><\/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-237.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3133,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3132","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=3132"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3132\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3133"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}