{"id":4008,"date":"2024-12-04T08:33:16","date_gmt":"2024-12-04T08:33:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/chuan-hoa-kieu-du-lieu-kho-do-voi-cong-cu-power-query-trong-excel\/"},"modified":"2024-12-04T08:33:16","modified_gmt":"2024-12-04T08:33:16","slug":"chuan-hoa-kieu-du-lieu-kho-do-voi-cong-cu-power-query-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/chuan-hoa-kieu-du-lieu-kho-do-voi-cong-cu-power-query-trong-excel\/","title":{"rendered":"Chu\u1ea9n ho\u00e1 ki\u1ec3u d\u1eef li\u1ec7u \u201cKh\u00f3 \u0111\u1ee1\u201d v\u1edbi c\u00f4ng c\u1ee5 Power Query trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-Bh-YYrla#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Power Query \u0111\u1ec3 chu\u1ea9n ho\u00e1 l\u1ea1i nh\u1eefng ki\u1ec3u b\u1ed1 tr\u00ed d\u1eef li\u1ec7u kh\u00f3, ph\u1ee9c t\u1ea1p trong Excel.<\/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-675013cb7701b\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Chuan_hoa_kieu_du_lieu_%E2%80%9CKho_do%E2%80%9D_voi_cong_cu_Power_Query_trong_Excel\" title=\"Chu\u1ea9n ho\u00e1 ki\u1ec3u d\u1eef li\u1ec7u \u201cKh\u00f3 \u0111\u1ee1\u201d v\u1edbi c\u00f4ng c\u1ee5 Power Query trong Excel\">Chu\u1ea9n ho\u00e1 ki\u1ec3u d\u1eef li\u1ec7u \u201cKh\u00f3 \u0111\u1ee1\u201d v\u1edbi c\u00f4ng c\u1ee5 Power Query trong Excel<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Dat_van_de\" title=\"\u0110\u1eb7t v\u1ea5n \u0111\u1ec1\">\u0110\u1eb7t v\u1ea5n \u0111\u1ec1<\/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\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Huong_xu_ly\" title=\"H\u01b0\u1edbng x\u1eed l\u00fd\">H\u01b0\u1edbng x\u1eed l\u00fd<\/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\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Cach_thuc_hien_voi_Power_Query\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n v\u1edbi Power Query\">C\u00e1ch th\u1ef1c hi\u1ec7n 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-5\" href=\"https:\/\/blog.hocexcel.online\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Buoc_1_Xu_ly_ban_dau\" title=\"B\u01b0\u1edbc 1: X\u1eed l\u00fd ban \u0111\u1ea7u\">B\u01b0\u1edbc 1: X\u1eed l\u00fd ban \u0111\u1ea7u<\/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\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Buoc_2_Them_cot\" title=\"B\u01b0\u1edbc 2: Th\u00eam c\u1ed9t\">B\u01b0\u1edbc 2: Th\u00eam c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Buoc_3_Thuc_hien_Pivot_Column\" title=\"B\u01b0\u1edbc 3: Th\u1ef1c hi\u1ec7n Pivot Column\">B\u01b0\u1edbc 3: Th\u1ef1c hi\u1ec7n Pivot Column<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Buoc_4_FillDown_va_Loc\" title=\"B\u01b0\u1edbc 4:\u00a0FillDown v\u00e0 L\u1ecdc\">B\u01b0\u1edbc 4:\u00a0FillDown v\u00e0 L\u1ecdc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Buoc_5_Hoan_thanh_va_Load_tro_lai_Excel\" title=\"B\u01b0\u1edbc 5:\u00a0Ho\u00e0n th\u00e0nh v\u00e0 Load tr\u1edf l\u1ea1i Excel\">B\u01b0\u1edbc 5:\u00a0Ho\u00e0n th\u00e0nh v\u00e0 Load tr\u1edf l\u1ea1i Excel<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuan_hoa_kieu_du_lieu_%E2%80%9CKho_do%E2%80%9D_voi_cong_cu_Power_Query_trong_Excel\"><\/span>Chu\u1ea9n ho\u00e1 ki\u1ec3u d\u1eef li\u1ec7u \u201cKh\u00f3 \u0111\u1ee1\u201d v\u1edbi c\u00f4ng c\u1ee5 Power Query trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Chu\u1ea9n ho\u00e1 d\u1eef li\u1ec7u, hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 \u0111\u01b0a d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng chu\u1ea9n c\u00f3 c\u1ea5u tr\u00fac \u0111\u00fang v\u1edbi c\u00e1c tr\u01b0\u1eddng th\u00f4ng tin ph\u00f9 h\u1ee3p, \u0111\u01b0\u1ee3c b\u1ed1 tr\u00ed m\u1ed9t c\u00e1ch khoa h\u1ecdc, h\u1ee3p l\u00fd, nh\u1eb1m gi\u00fap cho vi\u1ec7c qu\u1ea3n l\u00fd, ki\u1ec3m so\u00e1t c\u0169ng nh\u01b0 \u0111\u01b0a ra c\u00e1c b\u00e1o c\u00e1o th\u1ed1ng k\u00ea, ph\u00e2n t\u00edch m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3,\u2026.<\/p>\n<p style=\"text-align: justify\">C\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u chu\u1ea9n s\u1ebd gi\u00fap cho b\u1ea1n kh\u00f4ng ph\u1ea3i \u0111au \u0111\u1ea7u, m\u1ea5t qu\u00e1 nhi\u1ec1u th\u1eddi gian suy ngh\u0129 v\u1edbi nh\u1eefng c\u00f4ng th\u1ee9c Excel ph\u1ee9c t\u1ea1p, c\u00f4ng th\u1ee9c m\u1ea3ng, nh\u1eefng c\u00f4ng th\u1ee9c l\u1ed3ng nhau d\u00e0i c\u1ea3 c\u00e2y s\u1ed1,\u2026.<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dua-du-lieu-ve-dang-chuan-voi-power-query-trong-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Power Query \u0111\u1ec3 chu\u1ea9n ho\u00e1 d\u1eef li\u1ec7u<\/a><\/strong><\/em><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dat_van_de\"><\/span>\u0110\u1eb7t v\u1ea5n \u0111\u1ec1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> xem DATA v\u00ed d\u1ee5 sau:<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/1-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30347\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-4-1.png\" width=\"532\" height=\"805\" title=\"1-4-1\"><\/a><\/p>\n<p style=\"text-align: justify\">B\u1ea1n ngh\u0129 nh\u01b0 th\u1ebf n\u00e0o v\u1ec1 ki\u1ec3u b\u1ed1 tr\u00ed d\u1eef li\u1ec7u nh\u01b0 tr\u00ean???. R\u1ea5t kh\u00f3 \u0111\u1ec3 <em><strong>\u201cY\u00eau\u201d<\/strong> <\/em>\u0111\u01b0\u1ee3c ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p style=\"text-align: justify\">C\u00e1c th\u00f4ng tin v\u1ec1 gi\u1edbi t\u00ednh, tu\u1ed5i, tr\u00ecnh \u0111\u1ed9 n\u1eb1m trong 1 c\u1ed9t. C\u00e1c c\u1ed9t M\u00e3 nh\u00e2n vi\u00ean, S\u0110T th\u00ec ch\u1ed7 c\u00f3 d\u1eef li\u1ec7u, ch\u1ed7 kh\u00f4ng c\u00f3. Kh\u00f4ng \u0111\u1ee1 n\u1ed5i ph\u1ea3i kh\u00f4ng.<\/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-319.gif\" title=\"ex101_92019-nho-319\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Ph\u1ea3i chuy\u1ec3n \u0111\u1ed5i, nh\u1eefng chuy\u1ec3n nh\u01b0 n\u00e0o cho n\u00f3 \u0111\u00fang \u0111\u00e2y?, c\u1ea7n thi\u1ebft k\u1ebf l\u1ea1i v\u1edbi nh\u1eefng tr\u01b0\u1eddng th\u00f4ng tin n\u00e0o \u0111\u00e2y?<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Huong_xu_ly\"><\/span>H\u01b0\u1edbng x\u1eed l\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e2u tr\u1ea3 l\u1eddi cho v\u1ea5n \u0111\u1ec1 tr\u00ean l\u00e0:<\/p>\n<p style=\"text-align: justify\">C\u1ed9t th\u00f4ng tin trong d\u1eef li\u1ec7u g\u1ed1c ch\u1ee9a c\u00e1c th\u00f4ng tin v\u1ec1 Gi\u1edbi t\u00ednh, Tu\u1ed5i, Tr\u00ecnh \u0111\u1ed9 c\u1ee7a m\u1ed7i nh\u00e2n vi\u00ean. V\u1ea5n \u0111\u1ec1 c\u1ee7a ta n\u1eb1m \u1edf \u0111\u00e2y v\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft l\u00e0 ta n\u00ean t\u00e1ch c\u00e1c th\u00f4ng tin n\u00e0y ra l\u00e0m ti\u00eau \u0111\u1ec1 c\u1ed9t v\u1edbi c\u00e1c c\u1ed9t l\u00e0\u00a0Gi\u1edbi t\u00ednh, Tu\u1ed5i, Tr\u00ecnh \u0111\u1ed9.<\/p>\n<p style=\"text-align: justify\">V\u1edbi c\u00e1c c\u1ed9t v\u1ec1 M\u00e3 nh\u00e2n vi\u00ean, S\u0110T ta c\u0169ng ph\u1ea3i x\u1eed l\u00fd nh\u01b0 n\u00e0o \u0111\u1ec3 b\u1ecf h\u1ebft c\u00e1c kho\u1ea3ng tr\u1ed1ng \u0111\u00f3 \u0111i, ch\u1ec9 gi\u1eef l\u1ea1i nh\u1eefng d\u00f2ng c\u00f3 d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n n\u00e0y h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> \u0111\u1ebfn v\u1edbi ph\u1ea7n c\u00e1ch th\u1ef1c hi\u1ec7n.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_thuc_hien_voi_Power_Query\"><\/span>C\u00e1ch th\u1ef1c hi\u1ec7n v\u1edbi Power Query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong ph\u1ea7n n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a>s\u1ebd x\u1eed l\u00fd d\u1eef li\u1ec7u \u201cKh\u00f3 \u0111\u1ee1\u201d v\u00e0 r\u1ea5t chi l\u00e0 \u201cO\u00e1i o\u0103m\u201d tr\u00ean v\u1edbi c\u00f4ng c\u1ee5 Power Query trong Excel. Ta s\u1ebd c\u00f3 c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Buoc_1_Xu_ly_ban_dau\"><\/span>B\u01b0\u1edbc 1: X\u1eed l\u00fd ban \u0111\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Sau khi \u0111\u00e3 t\u1ea1o b\u1ea3ng, \u0111\u1eb7t m\u1ed9t c\u00e1i t\u00ean n\u00e0o \u0111\u00f3 cho d\u1eef li\u1ec7u\u00a0(m\u00ecnh \u0111\u00e3 \u0111\u1eb7t l\u00e0 DATA). Ta th\u1ef1c hi\u1ec7n Input b\u1ea3ng DATA n\u00e0y v\u00e0o Power Query Editor. Xo\u00e1 b\u1ecf b\u01b0\u1edbc Changed Type v\u00e0 n\u00f3 s\u1ebd tr\u00f4ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30350\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-4-1024x576-1.png\" width=\"1024\" height=\"576\" title=\"2-4-1024x576-1\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n ng\u1eafm ki\u1ec3u d\u1eef li\u1ec7u \u201ckh\u00f3 \u0111\u1ee1\u201d n\u00e0y m\u1ed9t ch\u00fat r\u1ed3i ta s\u1ebd th\u1ef1c hi\u1ec7n ti\u1ebfp:<\/p>\n<p style=\"padding-left: 30px;text-align: justify\">\u2013 Trong v\u00ed d\u1ee5 n\u00e0y kh\u00f4ng c\u00f3. Tuy nhi\u00ean, tr\u01b0\u1eddng h\u1ee3p c\u00f3 gi\u00e1 tr\u1ecb <em>null <\/em>trong c\u1ed9t Th\u00f4ng tin th\u00ec b\u1ea1n s\u1ebd l\u1ecdc v\u00e0 lo\u1ea1i b\u1ecf nh\u1eefng gi\u00e1 tr\u1ecb <em>null<\/em>\u00a0n\u00e0y \u0111i (\u1edf \u0111\u00e2y m\u00ecnh v\u1eabn th\u1ef1c hi\u1ec7n \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o nh\u1eefng l\u1ea7n sau n\u1ebfu c\u00f3 d\u1eef li\u1ec7u tr\u1ed1ng trong b\u1ea3ng DATA g\u1ed1c th\u00ec thao t\u00e1c n\u00e0y s\u1ebd lo\u1ea1i b\u1ecf nh\u1eefng d\u00f2ng tr\u1ed1ng \u0111\u00f3 cho ch\u00fang ta).<\/p>\n<p style=\"padding-left: 30px;text-align: justify\">\u2013 Ti\u1ebfp theo, ch\u1ecdn c\u1ed9t M\u00e3 nh\u00e2n vi\u00ean, v\u00e0o Tab Tranform v\u00e0 Fill -&gt; Down \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb <em>null\u00a0<\/em>n\u00e0o trong c\u1ed9t n\u00e0y.<\/p>\n<p style=\"text-align: justify\">Sau khi th\u1ef1c hi\u1ec7n nh\u01b0 tr\u00ean, d\u1eef li\u1ec7u ban \u0111\u1ea7u s\u1ebd gi\u1ed1ng nh\u01b0 sau <em>(h\u00ecnh \u0111\u00e3 c\u1eaft b\u1edbt 1 ph\u1ea7n)<\/em>:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/3-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30351\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-3-1024x328-1.png\" width=\"1024\" height=\"328\" title=\"3-3-1024x328-1\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Buoc_2_Them_cot\"><\/span>B\u01b0\u1edbc 2: Th\u00eam c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ti\u1ebfp theo, ta s\u1ebd th\u00eam c\u1ed9t Modulo<\/p>\n<p style=\"text-align: justify\">T\u1ea1i Tab Add Column, b\u1ea1n t\u00ecm t\u1edbi nh\u00f3m From Number, trong danh s\u00e1ch s\u1ed5 xu\u1ed1ng c\u1ee7a ph\u1ea7n Standard b\u1ea1n ch\u1ecdn Modulo, s\u1ebd c\u00f3 1 h\u1ed9p tho\u1ea1i xu\u1ea5t hi\u1ec7n ra v\u00e0 b\u1ea1n g\u00f5 v\u00e0o s\u1ed1 3 nh\u01b0 h\u00ecnh.<\/p>\n<p style=\"text-align: justify\">V\u00ec sao ph\u1ea3i l\u00e0m vi\u1ec7c \u0111\u00f3?. Ta th\u1ea5y th\u00f4ng tin c\u1ee7a m\u1ed7i M\u00e3 nh\u00e2n vi\u00ean s\u1ebd c\u00f3 3 d\u00f2ng \u0111\u00f3 l\u00e0 gi\u1edbi t\u00ednh, tu\u1ed5i, v\u00e0 tr\u00ecnh \u0111\u1ed9 (nh\u00e2n vi\u00ean n\u00e0o c\u0169ng c\u00f3 3 d\u00f2ng n\u00e0y).<\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c \u0111\u00e1nh s\u1ed1 Modulo n\u00e0y s\u1ebd nh\u01b0 sau:<\/p>\n<ul style=\"list-style-type: disc;text-align: justify\">\n<li style=\"padding-left: 30px;text-align: justify\">S\u1ed1 0 s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi gi\u1edbi t\u00ednh<\/li>\n<li style=\"padding-left: 30px;text-align: justify\">S\u1ed1 1 s\u1ebd\u00a0t\u01b0\u01a1ng \u1ee9ng v\u1edbi tu\u1ed5i<\/li>\n<li style=\"padding-left: 30px;text-align: justify\">S\u1ed1\u00a02\u00a0s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi\u00a0tr\u00ecnh \u0111\u1ed9<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/4-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30352\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-4-1024x322-1.png\" width=\"1024\" height=\"322\" title=\"4-4-1024x322-1\"><\/a><\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 14pt\"><strong>L\u01b0u \u00fd:<\/strong> <\/span>Mu\u1ed1n th\u1ef1c hi\u1ec7n\u00a0c\u00e1c thao t\u00e1c\u00a0trong nh\u00f3m\u00a0From Number th\u00ec c\u1ed9t hi\u1ec7n t\u1ea1i m\u00e0 b\u1ea1n \u0111ang ch\u1ecdn ph\u1ea3i l\u00e0 \u0111\u1ecbnh d\u1ea1ng Number (n\u1ebfu l\u00e0 Text th\u00ec b\u1ea1n s\u1ebd kh\u00f4ng ch\u1ecdn \u0111\u01b0\u1ee3c m\u1ee5c Standard), b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a 1 c\u1ed9t n\u00e0o \u0111\u00f3 v\u1ec1 d\u1ea1ng s\u1ed1 r\u1ed3i th\u1ef1c hi\u1ec7n b\u01b0\u1edbc tr\u00ean (n\u1ebfu c\u00f3 th\u1ec3), ho\u1eb7c kh\u00f4ng th\u00ec b\u1ea1n s\u1ebd ch\u00e8n th\u00eam 1 c\u1ed9t\u00a0Index n\u1eefa ch\u1eb3ng h\u1ea1n b\u1eb1ng ch\u1ecdn Index Column trong Tab Add Column (nh\u01b0 m\u00ecnh \u0111\u00e3 th\u1ef1c hi\u1ec7n).<\/p>\n<p style=\"text-align: justify\">Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc tr\u00ean th\u00ec b\u1ea3ng DATA c\u1ee7a ta s\u1ebd tr\u00f4ng nh\u01b0 n\u00e0y \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/5-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30353\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-2-1024x363-1.png\" width=\"1024\" height=\"363\" title=\"5-2-1024x363-1\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Buoc_3_Thuc_hien_Pivot_Column\"><\/span>B\u01b0\u1edbc 3: Th\u1ef1c hi\u1ec7n Pivot Column<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ch\u1ecdn c\u1ed9t Modulo, sau \u0111\u00f3 v\u00e0o Tab Transform v\u00e0 ch\u1ecdn Pivot Column.<\/p>\n<ul style=\"list-style-type: disc;text-align: justify\">\n<li style=\"padding-left: 30px;text-align: justify\">Values Column b\u1ea1n ch\u1ecdn l\u00e0 Th\u00f4ng tin<\/li>\n<li style=\"padding-left: 30px;text-align: justify\">Trong ph\u1ea7n Advanced options b\u1ea1n ch\u1ecdn Don\u2019t Aggregate (Kh\u00f4ng t\u1ed5ng h\u1ee3p)<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/6-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30354\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-2-1024x460-1.png\" width=\"1024\" height=\"460\" title=\"6-2-1024x460-1\"><\/a><\/p>\n<p style=\"text-align: justify\">Ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1edbi b\u01b0\u1edbc n\u00e0y nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/7-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30355\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-1-1024x383-1.png\" width=\"1024\" height=\"383\" title=\"7-1-1024x383-1\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Buoc_4_FillDown_va_Loc\"><\/span>B\u01b0\u1edbc 4:\u00a0FillDown v\u00e0 L\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">G\u1ea7n ho\u00e0n th\u00e0nh r\u1ed3i \u0111\u1ea5y . \u1ede b\u01b0\u1edbc n\u00e0y, ta th\u1ef1c hi\u1ec7n c\u00e1c vi\u1ec7c sau:<\/p>\n<ul style=\"list-style-type: disc;text-align: justify\">\n<li style=\"text-align: justify\">Ch\u1ecdn c\u1ed9t c\u00f3 ti\u00eau \u0111\u1ec1 l\u00e0 1 v\u00e0 2, v\u00e0o Tab Transform t\u00ecm t\u1edbi Fill -&gt; Down<\/li>\n<li style=\"text-align: justify\">Sau \u0111\u00f3, l\u1ecdc c\u1ed9t c\u00f3 ti\u00eau \u0111\u1ec1 l\u00e0 0, l\u1ecdc b\u1ecf c\u00e1 gi\u00e1 tr\u1ecb <em>null.<\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 sau b\u01b0\u1edbc n\u00e0y\u00a0nh\u01b0 sau, nh\u00ecn c\u00f3 v\u1ebb kh\u1ea3 quan h\u01a1n r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/8-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30356\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-1-1024x412-1.png\" width=\"1024\" height=\"412\" title=\"8-1-1024x412-1\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Buoc_5_Hoan_thanh_va_Load_tro_lai_Excel\"><\/span>B\u01b0\u1edbc 5:\u00a0Ho\u00e0n th\u00e0nh v\u00e0 Load tr\u1edf l\u1ea1i Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Th\u1ef1c hi\u1ec7n xo\u00e1 c\u1ed9t Index \u0111i (n\u1ebfu t\u1ea1i <strong>B\u01b0\u1edbc 2<\/strong> b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch th\u00eam 1 c\u1ed9t Index nh\u01b0 m\u00ecnh l\u00e0m)<\/p>\n<p style=\"text-align: justify\">\u0110\u1ed5i t\u00ean c\u00e1c c\u1ed9t:<\/p>\n<ul style=\"list-style-type: disc;text-align: justify\">\n<li>C\u1ed9t c\u00f3 t\u00ean 0 th\u00e0nh c\u1ed9t Gi\u1edbi t\u00ednh<\/li>\n<li>C\u1ed9t c\u00f3 t\u00ean 1 th\u00e0nh Tu\u1ed5i<\/li>\n<li>C\u1ed9t c\u00f3 t\u00ean 2 th\u00e0nh\u00a0Tr\u00ecnh \u0111\u1ed9<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ch\u00ednh\u00a0s\u1eeda \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c tr\u01b0\u1eddng (c\u1ed9t) d\u1eef li\u1ec7u, c\u0169ng nh\u01b0 di chuy\u1ec3n v\u1ecb tr\u00ed gi\u1eefa c\u00e1c c\u1ed9t cho ph\u00f9 h\u1ee3p,\u2026.<\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y, ta s\u1ebd\u00a0Load b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y v\u00e0o Excel.<\/p>\n<p style=\"text-align: justify\">Th\u1ef1c hi\u1ec7n Close &amp; Load To\u2026 r\u1ed3i ch\u1ecdn c\u00e1ch xem DATA sau khi \u0111\u00e3 x\u1eed l\u00fd c\u0169ng nh\u01b0 ch\u1ecdn v\u00f9ng \u0111\u1ec3 \u0111\u1eb7t DATA n\u00e0y.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/10-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30358\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-1-1024x517-1.png\" width=\"1024\" height=\"517\" title=\"10-1-1024x517-1\"><\/a><\/p>\n<p style=\"text-align: justify\">Qua c\u00e1c b\u01b0\u1edbc (c\u0169ng kh\u00e1 d\u00e0i ph\u1ea3i kh\u00f4ng ), nh\u01b0ng kh\u00f4ng sao, th\u00e0nh qu\u1ea3 m\u00e0 ta c\u00f3 \u0111\u01b0\u1ee3c x\u1ee9ng \u0111\u00e1ng ph\u1ea3i kh\u00f4ng n\u00e0o. M\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac l\u1ea1i m\u1ed9t c\u00e1ch h\u1ee3p l\u00fd, \u0111\u00e3 \u0111\u01b0\u1ee3c chu\u1ea9n ho\u00e1 qua c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n m\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> \u0111\u00e3 gi\u1edbi thi\u1ec7u \u1edf tr\u00ean.<\/p>\n<p style=\"text-align: justify\">Sau khi \u0111\u00e3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c trong Power Query, v\u00e0 t\u1ea5t nhi\u00ean l\u00e0 nh\u1eefng thao t\u00e1c m\u00e0 b\u1ea1n th\u1ef1c hi\u1ec7n n\u00e0y \u0111\u00e3 \u0111\u01b0\u1ee3c M Code ghi l\u1ea1i. Khi b\u1ea1n th\u00eam d\u1eef li\u1ec7u v\u00e0o DATA g\u1ed1c ban \u0111\u1ea7u th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n Refresh, ngay l\u1eadp t\u1ee9c b\u1ea3ng k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt cho b\u1ea1n m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, ch\u00ednh x\u00e1c.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch th\u1ef1c hi\u1ec7n chuy\u1ec3n \u0111\u1ed5i ki\u1ec3u d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p nh\u01b0 tr\u00ean v\u1ec1 d\u1ea1ng chu\u1ea9n, m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c bi\u1ebfn \u0111\u1ed5i v\u1ec1 \u0111\u00fang c\u1ea5u tr\u00fac, b\u1ed1 tr\u00ed m\u1ed9t c\u00e1ch khoa h\u1ecdc, th\u1ed1ng nh\u1ea5t gi\u1eefa c\u00e1c tr\u01b0\u1eddng th\u00f4ng tin.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, vi\u1ec7c t\u1ed5 ch\u1ee9c 1 b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng khoa h\u1ecdc, kh\u00f4ng tu\u00e2n theo c\u1ea5u tr\u00fac n\u00e0o c\u1ea3 s\u1ebd g\u00e2y ra r\u1ea5t nhi\u1ec1u kh\u00f3 kh\u0103n trong qu\u00e1 tr\u00ecnh t\u1ed5ng h\u1ee3p, b\u00e1o c\u00e1o c\u0169ng nh\u01b0 l\u1ea5y \u0111i c\u1ee7a b\u1ea1n r\u1ea5t nhi\u1ec1u th\u1eddi gian trong c\u00f4ng vi\u1ec7c,\u2026 V\u1edbi c\u00f4ng c\u1ee5 r\u1ea5t m\u1ea1nh l\u00e0 Power Query c\u00f3 th\u1ec3 s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd \u0111\u01b0\u1ee3c. Tuy nhi\u00ean, n\u1ebfu nh\u01b0 b\u1ea1n t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u t\u1ed1t ngay t\u1eeb ban \u0111\u1ea7u th\u00ec m\u00ecnh v\u1eabn ngh\u0129 l\u00e0 t\u1ed1t h\u01a1n.<\/p>\n<hr>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dua-du-lieu-ve-dang-chuan-voi-power-query-trong-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Power Query \u0111\u1ec3 chu\u1ea9n ho\u00e1 d\u1eef li\u1ec7u<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html\">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<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/?s=power+bi\">H\u00e0m DAX trong Power BI<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"https:\/\/hocexcel.online\/course\/preview\/pbi101-microsoft-power-bi-desktop-business-intelligence-trong-tam-tay\">PBI101 \u2013 Microsoft Power BI Desktop, Business Intelligence trong t\u1ea7m tay<\/a><\/strong><\/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-319.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4009,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4008","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\/4008","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=4008"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4008\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4009"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}