{"id":822,"date":"2024-12-02T02:54:16","date_gmt":"2024-12-02T02:54:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/hop-nhat-du-lieu-trong-excel-va-hop-nhat-nhieu-trang-tinh-vao-mot-trang-tinh\/"},"modified":"2024-12-02T02:54:16","modified_gmt":"2024-12-02T02:54:16","slug":"hop-nhat-du-lieu-trong-excel-va-hop-nhat-nhieu-trang-tinh-vao-mot-trang-tinh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/hop-nhat-du-lieu-trong-excel-va-hop-nhat-nhieu-trang-tinh-vao-mot-trang-tinh\/","title":{"rendered":"H\u1ee3p nh\u1ea5t d\u1eef li\u1ec7u trong Excel v\u00e0 h\u1ee3p nh\u1ea5t nhi\u1ec1u trang t\u00ednh v\u00e0o m\u1ed9t trang t\u00ednh"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a> s\u1ebd tr\u00ecnh b\u00e0y c\u00e1c c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 h\u1ee3p nh\u1ea5t c\u00e1c trang trong Excel b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh ho\u1eb7c k\u1ebft h\u1ee3p nhi\u1ec1u trang b\u1eb1ng c\u00e1ch sao ch\u00e9p d\u1eef li\u1ec7u c\u1ee7a ch\u00fang.<\/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-674d215724ac7\" 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\/hop-nhat-du-lieu-trong-excel-va-hop-nhat-nhieu-trang-tinh-vao-mot-trang-tinh.html#Hop_nhat_du_lieu_tu_nhieu_trang_tinh_sang_mot_trang_tinh\" title=\"H\u1ee3p nh\u1ea5t d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh sang\u00a0m\u1ed9t trang t\u00ednh\">H\u1ee3p nh\u1ea5t d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh sang\u00a0m\u1ed9t trang t\u00ednh<\/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\/hop-nhat-du-lieu-trong-excel-va-hop-nhat-nhieu-trang-tinh-vao-mot-trang-tinh.html#Lam_the_nao_de_hop_nhat_cac_trang_tinh_Excel_thanh_mot\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 h\u1ee3p nh\u1ea5t c\u00e1c trang t\u00ednh Excel th\u00e0nh m\u1ed9t\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 h\u1ee3p nh\u1ea5t c\u00e1c trang t\u00ednh Excel th\u00e0nh m\u1ed9t<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/hop-nhat-du-lieu-trong-excel-va-hop-nhat-nhieu-trang-tinh-vao-mot-trang-tinh.html#Lam_the_nao_de_ket_hop_bang_tinh_Excel_voi_Consolidate_Worksheets_Wizard\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 k\u1ebft h\u1ee3p b\u1ea3ng t\u00ednh Excel v\u1edbi Consolidate Worksheets Wizard \">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 k\u1ebft h\u1ee3p b\u1ea3ng t\u00ednh Excel v\u1edbi Consolidate Worksheets Wizard <\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Hop_nhat_du_lieu_tu_nhieu_trang_tinh_sang_mot_trang_tinh\"><\/span><strong>H\u1ee3p nh\u1ea5t d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh sang\u00a0m\u1ed9t trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 h\u1ee3p nh\u1ea5t d\u1eef li\u1ec7u trong Excel (n\u1eb1m trong m\u1ed9t b\u1ea3ng t\u00ednh ho\u1eb7c nhi\u1ec1u b\u1ea3ng t\u00ednh) l\u00e0 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00edch h\u1ee3p s\u1eb5n <a href=\"http:\/\/blog.ezworkapp.com\/vba11-%e2%97%8b-copy-du-lieu-tu-nhieu-bao-cao-vao-1-bao-cao-tong-khong-can-mo-bao-cao-con.html\"><em><strong>Excel Consolidate<\/strong><\/em><\/a>.<\/p>\n<p>H\u00e3y xem x\u00e9t v\u00ed d\u1ee5 sau \u0111\u00e2y: Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 b\u00e1o c\u00e1o t\u1eeb c\u00e1c v\u0103n ph\u00f2ng chi nh\u00e1nh c\u00f4ng ty v\u00e0 b\u1ea1n mu\u1ed1n h\u1ee3p nh\u1ea5t v\u00e0o m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u1ec3 b\u1ea1n c\u00f3 m\u1ed9t b\u00e1o c\u00e1o t\u1ed5ng doanh thu c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m.<\/p>\n<p>Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y, ba b\u1ea3ng t\u00ednh c\u1ea7n h\u1ee3p nh\u1ea5t c\u00f3 c\u1ea5u tr\u00fac d\u1eef li\u1ec7u t\u01b0\u01a1ng t\u1ef1, nh\u01b0ng c\u00e1c s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t kh\u00e1c nhau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-1.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4415 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-1.bmp\" width=\"600\" height=\"283\" title=\"new-bitmap-image-2-1\"><\/a><\/p>\n<p>\u0110\u1ec3 h\u1ee3p nh\u1ea5t d\u1eef li\u1ec7u th\u00e0nh m\u1ed9t, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>1.S\u1eafp x\u1ebfp d\u1eef li\u1ec7u ngu\u1ed3n: \u00a0<\/strong>\u0110\u1ec3 t\u00ednh n\u0103ng Excel Consolidate ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, ph\u1ea3i \u0111\u1ea3m b\u1ea3o r\u1eb1ng:\u00b7<\/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-48.gif\" title=\"ex101_92019-nho-48\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>M\u1ed7i d\u00e3y (t\u1eadp d\u1eef li\u1ec7u) b\u1ea1n mu\u1ed1n h\u1ee3p nh\u1ea5t n\u1eb1m tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh ri\u00eang bi\u1ec7t. Kh\u00f4ng \u0111\u1eb7t b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u n\u00e0o tr\u00ean b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n h\u1ee3p nh\u1ea5t.\u00b7<\/li>\n<li>M\u1ed7i trang c\u00f3 c\u00f9ng b\u1ed1 c\u1ee5c, m\u1ed7i c\u1ed9t c\u00f3 ti\u00eau \u0111\u1ec1 v\u00e0 ch\u1ee9a d\u1eef li\u1ec7u t\u01b0\u01a1ng t\u1ef1.\u00b7<\/li>\n<li>Kh\u00f4ng c\u00f3 h\u00e0ng ho\u1eb7c c\u1ed9t tr\u1ed1ng trong b\u1ea5t k\u1ef3 danh s\u00e1ch n\u00e0o.<\/li>\n<\/ul>\n<p><strong>2. Ch\u1ea1y Excel Consolidate.<\/strong> Trong b\u1ea3ng t\u00ednh ch\u00ednh, nh\u1ea5p v\u00e0o \u00f4 b\u00ean tr\u00e1i ph\u00eda tr\u00ean, \u0111i t\u1edbi tab <em><strong>Data<\/strong><\/em> v\u00e0 nh\u1ea5p <strong><em>Consolidate<\/em><\/strong>.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4416 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-2.bmp\" width=\"648\" height=\"170\" title=\"new-bitmap-image-2-2\"><\/a><\/p>\n<p><strong>Ch\u00fa \u00fd:<\/strong> B\u1ea1n n\u00ean h\u1ee3p nh\u1ea5t d\u1eef li\u1ec7u v\u00e0o m\u1ed9t trang tr\u1ed1ng. N\u1ebfu b\u1ea3ng t\u00ednh ch\u00ednh c\u1ee7a b\u1ea1n \u0111\u00e3 c\u00f3 m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u, \u0111\u1ea3m b\u1ea3o c\u00f3 \u0111\u1ee7 kh\u00f4ng gian (c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t tr\u1ed1ng) \u0111\u1ec3 ch\u1ee9a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c h\u1ee3p nh\u1ea5t.<\/p>\n<p><strong>3. C\u1ea5u h\u00ecnh Consolidate settings.<\/strong> Khi h\u1ed9p tho\u1ea1i Consolidate xu\u1ea5t hi\u1ec7n, b\u1ea1n th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>Trong h\u1ed9p Function, ch\u1ecdn m\u1ed9t trong c\u00e1c h\u00e0m m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng \u0111\u1ec3 h\u1ee3p nh\u1ea5t d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh (Count, Average, Max, Min, v.v \u2026). Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta ch\u1ecdn Sum.<\/li>\n<li>Trong h\u1ed9p <em><strong>Reference box<\/strong><\/em>, nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Thu g\u1ecdn <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4425\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-9.bmp\" width=\"28\" height=\"22\" title=\"new-bitmap-image-2-9\">v\u00e0 ch\u1ecdn v\u00f9ng \u1edf trang t\u00ednh \u0111\u1ea7u ti\u00ean. Sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat Add \u0111\u1ec3 th\u00eam c\u00e1c v\u00f9ng kh\u00e1c. L\u1eb7p l\u1ea1i b\u01b0\u1edbc n\u00e0y cho t\u1ea5t c\u1ea3 c\u00e1c v\u00f9ng b\u1ea1n mu\u1ed1n h\u1ee3p nh\u1ea5t.<\/li>\n<\/ul>\n<p>N\u1ebfu m\u1ed9t ho\u1eb7c m\u1ed9t s\u1ed1 trang n\u1eb1m \u200b\u200btrong m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c, h\u00e3y nh\u1ea5p v\u00e0o Browse \u0111\u1ec3 t\u00ecm b\u1ea3ng t\u00ednh.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-3.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4417\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-3.bmp\" width=\"569\" height=\"392\" title=\"new-bitmap-image-2-3\"><\/a><\/p>\n<p><strong>4. C\u1ea5u h\u00ecnh Update settings<\/strong>. C\u0169ng trong h\u1ed9p tho\u1ea1i Consolidate, h\u00e3y ch\u1ecdn b\u1ea5t k\u1ef3 t\u00f9y ch\u1ecdn n\u00e0o sau \u0111\u00e2y:<\/p>\n<ul>\n<li>Ch\u1ecdn <em><strong>Top row<\/strong><\/em> v\u00e0 \/ ho\u1eb7c <em><strong>Left column<\/strong><\/em> ph\u00eda d\u01b0\u1edbi <strong><em>Use labels in<\/em><\/strong> n\u1ebfu b\u1ea1n mu\u1ed1n sao ch\u00e9p t\u00ean h\u00e0ng v\u00e0 \/ ho\u1eb7c t\u00ean c\u1ed9t t\u1eeb c\u00e1c trang t\u00ednh g\u1ed1c v\u00e0o trang h\u1ee3p nh\u1ea5t.<\/li>\n<li>Ch\u1ecdn <strong>Create links to source data check<\/strong> n\u1ebfu b\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u h\u1ee3p nh\u1ea5t c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng khi d\u1eef li\u1ec7u ngu\u1ed3n thay \u0111\u1ed5i. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, Excel s\u1ebd t\u1ea1o li\u00ean k\u1ebft t\u1edbi b\u1ea3ng t\u00ednh ngu\u1ed3n c\u1ee7a b\u1ea1n v\u00e0 th\u1ec3 hi\u1ec7n nh\u01b0 \u1ea3nh sau:<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-5.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4419 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-5.bmp\" width=\"594\" height=\"243\" title=\"new-bitmap-image-2-5\"><\/a><\/li>\n<\/ul>\n<p>N\u1ebfu b\u1ea1n m\u1edf r\u1ed9ng nh\u00f3m (b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong>\u201c+\u201d<\/strong>), sau \u0111\u00f3 nh\u1ea5p v\u00e0o \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb, tr\u00ean thanh c\u00f4ng th\u1ee9c s\u1ebd th\u1ec3 hi\u1ec7n m\u1ed9t li\u00ean k\u1ebft \u0111\u1ebfn d\u1eef li\u1ec7u ngu\u1ed3n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4420\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-6.bmp\" width=\"596\" height=\"300\" title=\"new-bitmap-image-2-6\"><\/p>\n<p>Nh\u01b0 b\u1ea1n th\u1ea5y, t\u00ednh n\u0103ng Excel Consolidate r\u1ea5t h\u1eefu \u00edch \u0111\u1ec3 t\u1eadp h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u trang t\u00ednh. Tuy nhi\u00ean, n\u00f3 c\u00f3 m\u1ed9t v\u00e0i h\u1ea1n ch\u1ebf. C\u1ee5 th\u1ec3, n\u00f3 ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng khi c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 v\u00e0 lu\u00f4n g\u1ed9p ch\u00fang l\u1ea1i b\u1eb1ng nhi\u1ec1u c\u00e1ch (sum, count, average, vv\u2026)<\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n k\u1ebft h\u1ee3p c\u00e1c trang t\u00ednh trong Excel b\u1eb1ng c\u00e1ch sao ch\u00e9p d\u1eef li\u1ec7u, ch\u1ee9c n\u0103ng n\u00e0y kh\u00f4ng hi\u1ec7u qu\u1ea3. \u0110\u1ec3 k\u1ebft h\u1ee3p v\u00e0i trang t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 c\u1ea7n k\u0129 n\u0103ng copy\/paste. Nh\u01b0ng n\u1ebfu b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p h\u00e0ng ch\u1ee5c trang t\u00ednh, th\u00ec sai s\u00f3t trong vi\u1ec7c copy\/paste th\u1ee7 c\u00f4ng l\u00e0 kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c k\u1ef9 thu\u1eadt sau \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u1ee3p nh\u1ea5t.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_hop_nhat_cac_trang_tinh_Excel_thanh_mot\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 h\u1ee3p nh\u1ea5t c\u00e1c trang t\u00ednh Excel th\u00e0nh m\u1ed9t<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u00ecn chung, c\u00f3 3 c\u00e1ch \u0111\u1ec3 h\u1ee3p nh\u1ea5t c\u00e1c b\u1ea3ng t\u00ednh Excel th\u00e0nh m\u1ed9t m\u00e0 kh\u00f4ng c\u1ea7n sao ch\u00e9p v\u00e0 d\u00e1n:<\/p>\n<ul>\n<li>S\u1eed d\u1ee5ng VBA<\/li>\n<li>Truy v\u1ea5n ngu\u1ed3n cho Excel<\/li>\n<li>Ti\u1ec7n \u00edch b\u1ed5 sung c\u1ee7a b\u00ean th\u1ee9 ba<\/li>\n<\/ul>\n<p>Ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u v\u1edbi l\u1ef1a ch\u1ecdn cu\u1ed1i c\u00f9ng, m\u1ed9t trong nh\u1eefng c\u00e1ch quen thu\u1ed9c v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng nh\u1ea5t.<\/p>\n<blockquote>\n<p>\u0110\u0103ng k\u00fd ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">l\u1edbp h\u1ecdc VBA \u1edf H\u00e0 N\u1ed9i<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_ket_hop_bang_tinh_Excel_voi_Consolidate_Worksheets_Wizard\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 k\u1ebft h\u1ee3p b\u1ea3ng t\u00ednh Excel v\u1edbi <em>Consolidate Worksheets Wizard <\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi \u0111\u1ecdc ti\u00eau \u0111\u1ec1 c\u1ee7a ph\u1ea7n n\u00e0y, m\u1ed9t s\u1ed1 b\u1ea1n c\u00f3 th\u1ec3 b\u1ecb b\u1ed1i r\u1ed1i. Khi n\u00f3i v\u1ec1 t\u00ednh n\u0103ng Excel Consolidate, H\u1ecdc Excel Online\u00a0ch\u1ec9 ra r\u1eb1ng n\u00f3 kh\u00f4ng th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c b\u1ea3ng b\u1eb1ng c\u00e1ch sao ch\u00e9p d\u1eef li\u1ec7u c\u1ee7a ch\u00fang. Ph\u1ea3i, t\u00f9y ch\u1ecdn t\u00edch h\u1ee3p trong Excel th\u00ec kh\u00f4ng th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c, nh\u01b0ng <strong>Ablebits Consolidate Worksheet Wizard<\/strong> th\u00ec c\u00f3 th\u1ec3<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t v\u00e0i trang t\u00ednh c\u00f3 ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c s\u1ea3n ph\u1ea9m kh\u00e1c nhau v\u00e0 b\u00e2y gi\u1edd b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p ch\u00fang v\u00e0o m\u1ed9t b\u1ea3ng nh\u01b0 sau:<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-7.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4421 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-7.bmp\" width=\"600\" height=\"531\" title=\"new-bitmap-image-2-7\"><\/a><\/p>\n<p><strong>K\u1ebft h\u1ee3p nhi\u1ec1u b\u1ea3ng t\u00ednh th\u00e0nh m\u1ed9t b\u1eb1ng 5 b\u01b0\u1edbc:<\/strong><\/p>\n<p>Gi\u1ea3 s\u1eed r\u1eb1ng b\u1ea1n \u0111\u00e3 c\u00e0i \u0111\u1eb7t <em><strong>Consolidate Worksheets Wizard<\/strong><\/em>, n\u0103m b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y s\u1ebd k\u1ebft h\u1ee3p c\u00e1c b\u1ea3ng t\u00ednh Excel th\u00e0nh m\u1ed9t.<\/p>\n<p><strong>1, B\u1eadt Consolidate Worksheets Wizard<\/strong>. Tr\u00ean thanh c\u00f4ng c\u1ee5 Excel, ch\u1ecdn tab Ablebits, ch\u1ecdn Merge v\u00e0 nh\u1ea5p v\u00e0o Consolidate Worksheets.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4422 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-8.bmp\" width=\"325\" height=\"166\" title=\"new-bitmap-image-2-8\"><\/p>\n<p><strong>2.\u00a0<\/strong><strong>Ch\u1ecdn c\u00e1c b\u1ea3ng t\u00ednh v\u00e0 v\u00f9ng h\u1ee3p nh\u1ea5t<\/strong>. Khi b\u1ea1n ch\u1ea1y Consolidate Worksheets, n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb m\u1ed9t danh s\u00e1ch c\u00e1c b\u1ea3ng t\u00ednh \u0111ang m\u1edf. Th\u00f4ng th\u01b0\u1eddng n\u00f3 s\u1ebd t\u1ef1 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u trong c\u00e1c b\u1ea3ng t\u00ednh li\u1ec7t k\u00ea. N\u1ebfu b\u1ea1n mu\u1ed1n ch\u1ecdn m\u1ed9t v\u00f9ng kh\u00e1c, h\u00e3y s\u1eed d\u1ee5ng bi\u1ec3u t\u01b0\u1ee3ng Thu g\u1ecdn.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-9.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4425\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-9.bmp\" width=\"25\" height=\"20\" title=\"new-bitmap-image-2-9\"><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-10.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4426 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-10.bmp\" width=\"600\" height=\"477\" title=\"new-bitmap-image-2-10\"><\/a><\/p>\n<p><strong>Ch\u00fa \u00fd:<\/strong> N\u1ebfu b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n h\u1ee3p nh\u1ea5t \u0111ang \u0111\u00f3ng, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat Add files \u2026 \u0111\u1ec3 ch\u1ecdn b\u1ea3ng t\u00ednh \u0111\u00f3.<\/p>\n<p><strong>3. Ch\u1ecdn lo\u1ea1i h\u1ee3p nh\u1ea5t<\/strong>. V\u00ec ch\u00fang ta mu\u1ed1n k\u1ebft h\u1ee3p nhi\u1ec1u trang b\u1eb1ng c\u00e1ch sao ch\u00e9p d\u1eef li\u1ec7u c\u1ee7a ch\u00fang, h\u00e3y ch\u1ecdn <strong><em>Copy data from selected ranges to one worksheet<\/em><\/strong> v\u00e0 nh\u1ea5p <em><strong>Next<\/strong>.<\/em><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-11.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4427 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-11.bmp\" width=\"600\" height=\"483\" title=\"new-bitmap-image-2-11\"><\/a><\/p>\n<p><strong>4. Ch\u1ecdn c\u00e1ch b\u1ea1n mu\u1ed1n h\u1ee3p nh\u1ea5t c\u00e1c trang t\u00ednh<\/strong>. Trong b\u01b0\u1edbc n\u00e0y, b\u1ea1n ph\u1ea3i ch\u1ecdn c\u1ea5u h\u00ecnh c\u00e0i \u0111\u1eb7t h\u1ee3p nh\u1ea5t v\u1edbi c\u00e1c b\u01b0\u1edbc sau: <strong>C\u00e1c t\u00f9y ch\u1ecdn d\u00e1n:<\/strong><\/p>\n<ul>\n<li><strong><em>Paste all<\/em><\/strong> \u2013 \u0111\u1ec3 sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb c\u0169ng nh\u01b0 c\u00e1c c\u00f4ng th\u1ee9c. \u2013 \u0111\u01b0\u1ee3c dung trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p.<\/li>\n<li><strong><em>Paste values only<\/em><\/strong> \u00a0\u2013 n\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n gi\u1eef c\u00e1c c\u00f4ng th\u1ee9c t\u1eeb c\u00e1c trang ngu\u1ed3n, h\u00e3y ch\u1ecdn t\u00f9y ch\u1ecdn n\u00e0y.<\/li>\n<li><strong><em>Paste link to data<\/em><\/strong> \u2013 li\u00ean k\u1ebft d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c h\u1ee3p nh\u1ea5t v\u1edbi d\u1eef li\u1ec7u ngu\u1ed3n. Ch\u1ecdn n\u00f3 n\u1ebfu b\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c h\u1ee3p nh\u1ea5t c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng khi d\u1eef li\u1ec7u ngu\u1ed3n thay \u0111\u1ed5i. N\u00f3 ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 <em>Create links to source data check<\/em> c\u1ee7a Excel Consolidate.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-12.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4428 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-12.bmp\" width=\"600\" height=\"472\" title=\"new-bitmap-image-2-12\"><\/a><\/p>\n<p><strong>Nh\u1eefng<\/strong><strong> l\u1ef1a ch\u1ecdn kh\u00e1c:<\/strong><\/p>\n<ul>\n<li><em><strong>My tables have headers<\/strong>:<\/em> T\u00f9y ch\u1ecdn n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n k\u1ebft h\u1ee3p c\u00e1c b\u1ea3ng c\u00f3 c\u1ed9t s\u1eafp x\u1ebfp kh\u00e1c nhau. \u0110\u1ec3 bi\u1ebft th\u00eam chi ti\u1ebft, vui l\u00f2ng xem v\u00ed d\u1ee5 1.<\/li>\n<li><strong><em>Copy data only for the matching columns in my first tables in the list<\/em><\/strong> \u2013 ch\u1ecdn n\u00f3 n\u1ebfu b\u1ea1n ch\u1ec9 h\u1ee3p nh\u1ea5t c\u00e1c c\u1ed9t nh\u1ea5t \u0111\u1ecbnh trong b\u1ea3ng t\u00ednh. \u0110\u1ec3 bi\u1ebft th\u00eam chi ti\u1ebft, vui l\u00f2ng xem v\u00ed d\u1ee5 2.<\/li>\n<li><strong><em>Preserve formatting<\/em><\/strong> \u2013 t\u1ef1 gi\u1ea3i th\u00edch v\u00e0 r\u1ea5t thu\u1eadn ti\u1ec7n.<\/li>\n<li><strong><em>Separate the copied ranges by a blank row<\/em><\/strong>\u2013 ch\u1ecdn tu\u1ef3 ch\u1ecdn n\u00e0y n\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam c\u00e1c h\u00e0ng tr\u1ed1ng gi\u1eefa c\u00e1c v\u00f9ng d\u1eef li\u1ec7u h\u1ee3p nh\u1ea5t.<\/li>\n<\/ul>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 ba\u0309n<\/a><\/p>\n<\/blockquote>\n<p>5.<strong>Ch\u1ecdn v\u00f9ng \u0111\u1eb7t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c h\u1ee3p nh\u1ea5t<\/strong>. Ch\u1ecdn n\u01a1i b\u1ea1n mu\u1ed1n xu\u1ea5t d\u1eef li\u1ec7u h\u1ee3p nh\u1ea5t: \u1edf m\u1ed9t trang b\u1ea3ng t\u00ednh m\u1edbi, m\u1ed9t t\u1ec7p l\u00e0m vi\u1ec7c m\u1edbi ho\u1eb7c m\u1ed9t v\u1ecb tr\u00ed nh\u1ea5t \u0111\u1ecbnh trong b\u1ea5t k\u1ef3 trang t\u00ednh n\u00e0o.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-13.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4430 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-13.bmp\" width=\"600\" height=\"479\" title=\"new-bitmap-image-2-13\"><\/a><\/p>\n<p>B\u1ea5m <em>Finish <\/em>v\u00e0 b\u1ea1n s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-14.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4431 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-14.bmp\" width=\"542\" height=\"655\" title=\"new-bitmap-image-2-14\"><\/a><\/p>\n<p><strong>C\u00e1c t\u00f9y ch\u1ecdn b\u1ed5 sung cho vi\u1ec7c tr\u1ed9n c\u00e1c trang t\u00ednh trong Excel<\/strong><\/p>\n<p>B\u1ed9 c\u00f4ng c\u1ee5 <strong>Consolidate Worksheets Wizard<\/strong> cung c\u1ea5p 2 t\u00f9y ch\u1ecdn \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c t\u00ecnh hu\u1ed1ng sau.<\/p>\n<p><strong>V\u00ed d\u1ee5 1. H\u1ee3p nh\u1ea5t c\u00e1c trang Excel v\u1edbi m\u1ed9t th\u1ee9 t\u1ef1 c\u00e1c c\u1ed9t kh\u00e1c nhau<\/strong>\u00a0Khi b\u1ea1n k\u1ebft h\u1ee3p c\u00e1c trang t\u00ednh \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi nh\u1eefng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c nhau, th\u1ee9 t\u1ef1 c\u00e1c c\u1ed9t th\u01b0\u1eddng kh\u00e1c nhau. \u0110\u1ec3 th\u1ee7 thu\u1eadt n\u00e0y x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c gi\u1eefa c\u00e1c c\u1ed9t, h\u00e3y ch\u1eafc ch\u1eafn b\u1ea1n \u0111\u00e3 ch\u1ecdn t\u00f9y ch\u1ecdn <strong>My tables have headers.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4433 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-16.bmp\" width=\"600\" height=\"480\" title=\"new-bitmap-image-2-16\"><\/p>\n<p>V\u00e0 k\u1ebft qu\u1ea3 l\u00e0, trang t\u00ednh c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ee3p nh\u1ea5t theo h\u00ecnh sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-15.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4435 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-15.bmp\" width=\"600\" height=\"344\" title=\"new-bitmap-image-2-15\"><\/a><\/p>\n<p><strong>V\u00ed d\u1ee5 2. H\u1ee3p nh\u1ea5t c\u00e1c c\u1ed9t nh\u1ea5t \u0111\u1ecbnh t\u1eeb nhi\u1ec1u trang t\u00ednh<\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u trang l\u1edbn v\u1edbi r\u1ea5t nhi\u1ec1u c\u1ed9t kh\u00e1c nhau, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 mu\u1ed1n k\u1ebft h\u1ee3p nh\u1eefng c\u00e1i quan tr\u1ecdng nh\u1ea5t v\u00e0o m\u1ed9t b\u1ea3ng. Gi\u1ea3i ph\u00e1p nhanh ch\u00f3ng l\u00e0 t\u1ea1o m\u1ed9t b\u1ea3n sao c\u1ee7a m\u1ed9t trong nh\u1eefng trang t\u00ednh, x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t kh\u00f4ng li\u00ean quan, ch\u1ec9 gi\u1eef l\u1ea1i nh\u1eefng c\u1ed9t b\u1ea1n mu\u1ed1n h\u1ee3p nh\u1ea5t. Sau \u0111\u00f3, ch\u1ea1y <strong>Consolidate Worksheets Wizard<\/strong>, v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn <strong>Copy data only for the matching columns in my first table in the list.<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-17.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4436 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-17.bmp\" width=\"600\" height=\"482\" title=\"new-bitmap-image-2-17\"><\/a><\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0,\u00a0<strong>Consolidate Worksheets Wizard\u00a0<\/strong>s\u1ebd t\u00ecm nh\u1eefng c\u1ed9t c\u00f3 c\u00f9ng t\u00ean trong nh\u1eefng trang t\u00ednh b\u1ea1n \u0111\u00e3 ch\u1ecdn v\u00e0 ch\u1ec9 sao ch\u00e9p d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng c\u1ed9t \u0111\u00f3.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-18.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4437 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-18.bmp\" width=\"600\" height=\"632\" title=\"new-bitmap-image-2-18\"><\/a><\/p>\n<p><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<p style=\"text-align: left\">Blog Ho\u0323c Excel online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 ba\u0309n<\/a>\u00a0cho \u0111\u00ea\u0301n n\u00e2ng cao v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u00ea\u0309u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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-48.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":823,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-822","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\/822","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=822"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/822\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/823"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}