{"id":7387,"date":"2024-12-21T17:30:18","date_gmt":"2024-12-21T17:30:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/lam-the-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai\/"},"modified":"2024-12-21T17:30:18","modified_gmt":"2024-12-21T17:30:18","slug":"lam-the-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/lam-the-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u trong Excel, chuy\u1ec3n \u0111\u1ed5i h\u00e0ng sang c\u1ed9t v\u00e0 ng\u01b0\u1ee3c l\u1ea1i"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Vi\u1ec7c chuy\u1ec3n d\u1eef li\u1ec7u trong Excel l\u00e0 m\u1ed9t v\u1ea5n \u0111\u1ec1 quen thu\u1ed9c v\u1edbi nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng.\u00a0Nh\u1ea5t l\u00e0 sau khi x\u00e2y d\u1ef1ng m\u1ed9t b\u1ea3ng ph\u1ee9c t\u1ea1p th\u00ec vi\u1ec7c chuy\u1ec3n d\u1eef li\u1ec7u s\u1ebd khi\u1ebfn ch\u00fang tr\u1edf n\u00ean r\u00f5 r\u00e0ng, gi\u00fap ph\u00e2n t\u00edch t\u1ed1t h\u01a1n ho\u1eb7c \u0111\u1ec3 v\u1ebd \u0111\u1ed3 th\u1ecb.<\/p>\n<p>Trong b\u00e0i n\u00e0y, <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn m\u1ed9t v\u00e0i c\u00e1ch \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c h\u00e0ng th\u00e0nh c\u00e1c c\u1ed9t (ho\u1eb7c c\u1ed9t th\u00e0nh h\u00e0ng) trong Excel, th\u1ef1c ra hai vi\u1ec7c \u0111\u00f3 l\u00e0 m\u1ed9t:). C\u00e1c gi\u1ea3i ph\u00e1p n\u00e0y d\u00f9ng \u0111\u01b0\u1ee3c trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 2016, 2013, 2010, 2007 v\u00e0 th\u1ea5p h\u01a1n. Bao g\u1ed3m nhi\u1ec1u kh\u1ea3 n\u0103ng c\u00f3 th\u1ec3 x\u1ea3y ra, gi\u1ea3i th\u00edch c\u00e1c l\u1ed7i \u0111i\u1ec3n h\u00ecnh nh\u1ea5t v\u00e0 \u0111\u01b0a ra c\u00e1c v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m v\u00e0 c\u00f4ng th\u1ee9c Transpose c\u1ee7a 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-6766fb29b426b\" 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\/lam-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai.html#Chuyen_doi_cac_hang_thanh_cac_cot_trong_Excel_bang_cach_su_dung_Paste_Special_Transpose\" title=\"Chuy\u1ec3n \u0111\u1ed5i c\u00e1c h\u00e0ng th\u00e0nh c\u00e1c c\u1ed9t trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Paste Special (Transpose)\">Chuy\u1ec3n \u0111\u1ed5i c\u00e1c h\u00e0ng th\u00e0nh c\u00e1c c\u1ed9t trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Paste Special (Transpose)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai.html#Lam_the_nao_de_chuyen_mot_bang_duoc_lien_ket_voi_du_lieu_ban_dau\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n m\u1ed9t b\u1ea3ng \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi d\u1eef li\u1ec7u ban \u0111\u1ea7u\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n m\u1ed9t b\u1ea3ng \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi d\u1eef li\u1ec7u ban \u0111\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai.html#Chuyen_du_lieu_trong_Excel_bang_cong_thuc\" title=\"Chuy\u1ec3n d\u1eef li\u1ec7u trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c\">Chuy\u1ec3n d\u1eef li\u1ec7u trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai.html#Chuyen_hang_sang_cot_trong_Excel_bang_ham_TRANSPOSE\" title=\"Chuy\u1ec3n h\u00e0ng sang c\u1ed9t trong Excel b\u1eb1ng h\u00e0m TRANSPOSE\">Chuy\u1ec3n h\u00e0ng sang c\u1ed9t trong Excel b\u1eb1ng h\u00e0m TRANSPOSE<\/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\/lam-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai.html#Chuyen_Hang_thanh_cot_cot_thanh_hang_bang_cach_su_dung_Ham_INDIRECT\" title=\"Chuy\u1ec3n H\u00e0ng th\u00e0nh c\u1ed9t \/ c\u1ed9t th\u00e0nh h\u00e0ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng H\u00e0m INDIRECT\">Chuy\u1ec3n H\u00e0ng th\u00e0nh c\u1ed9t \/ c\u1ed9t th\u00e0nh h\u00e0ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng H\u00e0m INDIRECT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai.html#Ham_INDIRECT_va_ADDRESS_%E2%80%93_cu_phap_va_logic\" title=\"H\u00e0m INDIRECT v\u00e0 ADDRESS \u2013 c\u00fa ph\u00e1p v\u00e0 logic\">H\u00e0m INDIRECT v\u00e0 ADDRESS \u2013 c\u00fa ph\u00e1p v\u00e0 logic<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Chuyen_doi_cac_hang_thanh_cac_cot_trong_Excel_bang_cach_su_dung_Paste_Special_Transpose\"><\/span>Chuy\u1ec3n \u0111\u1ed5i c\u00e1c h\u00e0ng th\u00e0nh c\u00e1c c\u1ed9t trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Paste Special (Transpose)<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n \u0111\u00e3 t\u1ea1o b\u1ea3ng t\u00ednh Excel t\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eefng g\u00ec b\u1ea1n th\u1ea5y \u1edf ph\u1ea7n tr\u00ean c\u1ee7a h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.\u00a0T\u00ean qu\u1ed1c gia \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo c\u00e1c c\u1ed9t, nh\u01b0ng danh s\u00e1ch c\u00e1c qu\u1ed1c gia c\u00f3 th\u1ec3 qu\u00e1 d\u00e0i, v\u00ec v\u1eady ch\u00fang ta n\u00ean thay \u0111\u1ed5i c\u00e1c c\u1ed9t th\u00e0nh h\u00e0ng \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi m\u00e0n h\u00ecnh:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6370\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-170.png\" width=\"600\" height=\"416\" title=\"excel-dialog-box-launcher-1-170\"><\/p>\n<ol>\n<li>Ch\u1ecdn h\u00e0ng v\u00e0 c\u1ed9t b\u1ea1n mu\u1ed1n chuy\u1ec3n.\u00a0N\u1ebfu b\u1ea1n mu\u1ed1n xoay to\u00e0n b\u1ed9 b\u1ea3ng, t\u1ee9c l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh, nh\u1ea5n\u00a0Ctrl + Home\u00a0v\u00e0\u00a0Ctrl + Shift + End\u00a0.<\/li>\n<li>Sao ch\u00e9p \u00f4 \u0111\u00e3 ch\u1ecdn b\u1eb1ng c\u00e1ch nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng ch\u1ecdn v\u00e0 ch\u1ecdn\u00a0<strong>Copy<\/strong>t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh ho\u1eb7c nh\u1ea5n\u00a0Ctrl + C\u00a0ho\u1eb7c nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>copy<\/em>\u00a0tr\u00ean\u00a0<em>tab Home tab &gt; Clipboard group<\/em>.<\/li>\n<li>Ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p d\u1eef li\u1ec7u \u0111\u00e3 chuy\u1ec3n \u0111\u1ed5i.<\/li>\n<\/ol>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0\u0110i\u1ec1u quan tr\u1ecdng l\u00e0 b\u1ea1n ch\u1ecdn m\u1ed9t \u00f4 n\u1eb1m ngo\u00e0i ph\u1ea1m vi ch\u1ee9a d\u1eef li\u1ec7u ban \u0111\u1ea7u c\u1ee7a b\u1ea1n, sao cho v\u00f9ng sao ch\u00e9p v\u00e0 v\u00f9ng d\u00e1n kh\u00f4ng ch\u1ed3ng ch\u00e9o.\u00a0V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n c\u00f3 4 c\u1ed9t v\u00e0 10 h\u00e0ng, khi b\u1ea1n chuy\u1ec3n v\u1ecb tr\u00ed c\u1ee7a b\u1ea3ng th\u00ec s\u1ebd c\u00f3 10 c\u1ed9t v\u00e0 4 h\u00e0ng.<\/p>\n<ol start=\"4\">\n<li>D\u00e1n d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c sao ch\u00e9p b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng\u00a0t\u00ednh n\u0103ng\u00a0<strong>Paste Special &gt; Transpose<\/strong>.\u00a0B\u1ea1n c\u00f3 th\u1ec3 m\u1edf\u00a0h\u1ed9p tho\u1ea1i Excel <strong>Paste Special<\/strong>\u00a0theo 3 c\u00e1ch:<\/li>\n<\/ol>\n<ul>\n<li>Tr\u00ean\u00a0<em>tab \u00a0Home tab &gt; Clipboard group,<\/em>, nh\u1ea5p v\u00e0o m\u0169i t\u00ean m\u00e0u \u0111en nh\u1ecf b\u00ean d\u01b0\u1edbi\u00a0n\u00fat\u00a0<em>Paste<\/em>, v\u00e0 ch\u1ecdn\u00a0<strong>Transpose<\/strong>\u00a0.<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 \u0111\u00edch v\u00e0 ch\u1ecdn\u00a0<strong>Paste Special<\/strong>t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Transpose<\/strong>\u00a0.<\/li>\n<li>V\u00e0 cu\u1ed1i c\u00f9ng, c\u00e1ch nhanh nh\u1ea5t l\u00e0 nh\u1ea5n\u00a0Ctrl + Alt + V\u00a0, ch\u1ecdn\u00a0<strong>Transpose<\/strong>v\u00e0 nh\u1ea5n\u00a0<em>OK<\/em>\u00a0.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-transpose.png\" alt=\"Select Transpose in the Paste Special dialog.\" title=\"excel-transpose\"><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0N\u1ebfu b\u1ea1n di chuy\u1ec3n c\u00e1c \u00f4 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c, ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u00f3 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i (d\u1ea5u $) trong t\u1ea5t c\u1ea3 c\u00e1c \u00f4.\u00a0\u0110i\u1ec1u n\u00e0y l\u00e0 c\u1ea7n thi\u1ebft v\u00ec c\u00e1c c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n v\u00e0 c\u00e1c tham chi\u1ebfu \u00f4 t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh.<\/p>\n<p>Nh\u01b0 b\u1ea1n v\u1eeba th\u1ea5y, t\u00ednh n\u0103ng Transpose c\u1ee7a Excel cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n chuy\u1ec3n \u0111\u1ed5i t\u1eeb h\u00e0ng sang c\u1ed9t (ho\u1eb7c c\u1ed9t sang h\u00e0ng) ch\u1ec9 trong v\u00e0i gi\u00e2y.\u00a0T\u00f4i tin r\u1eb1ng gi\u1ea3i ph\u00e1p n\u00e0y l\u00e0 m\u1ed9t c\u00e1ch th\u1ef1c s\u1ef1 t\u1ed1t n\u1ebfu ch\u1ec9 c\u1ea7n chuy\u1ec3n \u0111\u1ed5i b\u1ea3ng t\u00ednh m\u1ed9t l\u1ea7n duy nh\u1ea5t.\u00a0Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y c\u0169ng sao ch\u00e9p c\u00e1c \u0111\u1ecbnh d\u1ea1ng c\u1ee7a d\u1eef li\u1ec7u ban \u0111\u1ea7u c\u1ee7a b\u1ea1n, th\u00eam m\u1ed9t \u0111\u1ed1i s\u1ed1 trong v\u00f9ng \u1ea3nh h\u01b0\u1edfng.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-295.gif\" title=\"vba101_92019-nho-295\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-664.gif\" title=\"ex101_92019-nho-664\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Tuy nhi\u00ean, c\u00e1ch l\u00e0m \u0111\u01b0\u1ee3c \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean c\u00f3\u00a0<strong>hai nh\u01b0\u1ee3c<\/strong>\u00a0<strong>\u0111i\u1ec3m<\/strong> khi\u1ebfn n\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 gi\u1ea3i ph\u00e1p ho\u00e0n h\u1ea3o cho vi\u1ec7c chuy\u1ec3n ti\u1ebfp d\u1eef li\u1ec7u trong Excel:<\/p>\n<ul>\n<li>T\u00f9y ch\u1ecdn transpose\u00a0kh\u00f4ng th\u1ec3 d\u00f9ng khi sao ch\u00e9p \/ d\u00e1n b\u1ea3ng Excel \u0111\u1ea7y \u0111\u1ee7 h\u00e0m, kh\u00f4ng nh\u01b0 ph\u1ea1m vi \u0111\u01a1n gi\u1ea3n.\u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i sao ch\u00e9p b\u1ea3ng kh\u00f4ng c\u00f3 ti\u00eau \u0111\u1ec1 c\u1ed9t, ho\u1eb7c chuy\u1ec3n \u0111\u1ed5i n\u00f3 sang d\u1ea1ng <em>Range<\/em>\u00a0 (nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng v\u00e0 ch\u1ecdn\u00a0<em>\u00a0Table &gt; Convert to Range<\/em>\u00a0t\u1eeb menu ng\u1eef c\u1ea3nh).<\/li>\n<li>M\u1ed9t h\u1ea1n ch\u1ebf nghi\u00eam tr\u1ecdng h\u01a1n c\u1ee7a ph\u01b0\u01a1ng ph\u00e1p n\u00e0y l\u00e0 n\u00f3 t\u1ea1o ra m\u1ed9t b\u1ea3n sao c\u1ee7a d\u1eef li\u1ec7u ban \u0111\u1ea7u c\u1ee7a b\u1ea1n v\u00e0 b\u1ea5t c\u1ee9 khi n\u00e0o d\u1eef li\u1ec7u ngu\u1ed3n thay \u0111\u1ed5i, b\u1ea1n c\u1ea7n ph\u1ea3i l\u1eb7p l\u1ea1i qu\u00e1 tr\u00ecnh v\u00e0 xoay b\u1ea3ng m\u1ed9t l\u1ea7n n\u1eefa.\u00a0Ch\u1eb3ng ai mu\u1ed1n l\u00e3ng ph\u00ed th\u1eddi gian qu\u00fd gi\u00e1 c\u1ee7a h\u1ecd \u0111\u1ec3 chuy\u1ec3n \u0111i chuy\u1ec3n l\u1ea1i nh\u01b0 th\u1ebf, \u0111\u00fang kh\u00f4ng?<\/li>\n<\/ul>\n<h1><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_chuyen_mot_bang_duoc_lien_ket_voi_du_lieu_ban_dau\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n m\u1ed9t b\u1ea3ng \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi d\u1eef li\u1ec7u ban \u0111\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>H\u00e3y xem c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n h\u00e0ng sang c\u00e1c c\u1ed9t trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng k\u1ef9 thu\u1eadt sao ch\u00e9p \/ d\u00e1n quen thu\u1ed9c \u0111\u1ec3 li\u00ean k\u1ebft c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c di chuy\u1ec3n so v\u1edbi d\u1eef li\u1ec7u ban \u0111\u1ea7u.\u00a0\u0110i\u1ec1u t\u1ed1t nh\u1ea5t khi s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y l\u00e0 b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n thay \u0111\u1ed5i d\u1eef li\u1ec7u trong b\u1ea3ng ngu\u1ed3n, b\u1ea3ng chuy\u1ec3n \u0111\u1ed5i c\u0169ng s\u1ebd thay \u0111\u1ed5i v\u00e0 c\u1eadp nh\u1eadt cho ph\u00f9 h\u1ee3p.<\/p>\n<ol>\n<li>Copy h\u00e0ng b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i sang c\u00e1c c\u1ed9t (ho\u1eb7c c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c chuy\u1ec3n sang h\u00e0ng).<\/li>\n<li>Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng trong c\u00f9ng m\u1ed9t trang ho\u1eb7c m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c.<\/li>\n<li>M\u1edf\u00a0h\u1ed9p tho\u1ea1i\u00a0<em>Paste Special<\/em>, nh\u01b0\u00a0\u0111\u00e3 gi\u1ea3i th\u00edch trong c\u00e1ch tr\u01b0\u1edbc \u0111\u00f3\u00a0v\u00e0 ch\u1ecdn\u00a0<strong>Paste Link<\/strong>\u1edf g\u00f3c d\u01b0\u1edbi b\u00ean tr\u00e1i c\u1ee7a c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/paste-link.png\" alt=\"Open the Paste Special dialog and select Paste Link.\" title=\"paste-link\"><\/p>\n<p>B\u1ea1n s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/paste-links-data.png\" alt=\"Links to the original data are copied to a new table.\" title=\"paste-links-data\"><\/p>\n<ol start=\"4\">\n<li>Ch\u1ecdn d\u1eef li\u1ec7u m\u1edbi n\u00e0y v\u00e0 m\u1edf h\u1ed9p tho\u1ea1i Find and Replace\u00a0 th\u1ebf c\u1ee7a Excel (b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n\u00a0Ctrl + H\u00a0\u0111\u1ec3 chuy\u1ec3n \u0111\u1ebfn\u00a0tab\u00a0<em>Replace\u00a0<\/em>ngay).<\/li>\n<li>Thay th\u1ebf t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 \u201c=\u201d b\u1eb1ng \u201cxxx\u201d (b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 thay th\u1ebf n\u00f3 b\u1eb1ng b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 n\u00e0o kh\u00e1c kh\u00f4ng t\u1ed3n t\u1ea1i \u1edf b\u1ea5t k\u1ef3 n\u01a1i n\u00e0o trong d\u1eef li\u1ec7u th\u1ef1c c\u1ee7a b\u1ea1n).<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/replace-all.png\" alt=\"Replacing all '=' with some other characters\" title=\"replace-all\"><\/p>\n<p>\u0110i\u1ec1u n\u00e0y s\u1ebd bi\u1ebfn b\u1ea3ng c\u1ee7a b\u1ea1n th\u00e0nh m\u1ed9t c\u00e1i g\u00ec \u0111\u00f3 \u0111\u00e1ng s\u1ee3, nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, nh\u01b0ng \u0111\u1eebng lo l\u1eafng, ch\u1ec9 c\u1ea7n th\u00eam hai b\u01b0\u1edbc n\u1eefa v\u00e0 b\u1ea1n s\u1ebd \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n.<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<ol start=\"6\">\n<li>Sao ch\u00e9p b\u1ea3ng b\u1eb1ng gi\u00e1 tr\u1ecb \u201cxxx\u201d, v\u00e0 sau \u0111\u00f3 \u00e1p d\u1ee5ng\u00a0<em>Paste Special &gt; Transpose\u00a0<\/em> \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c c\u1ed9t th\u00e0nh h\u00e0ng, ho\u1eb7c c\u00e1c h\u00e0ng th\u00e0nh c\u1ed9t, t\u00f9y thu\u1ed9c v\u00e0o nhu c\u1ea7u c\u1ee7a b\u1ea1n.<\/li>\n<li>V\u00e0 cu\u1ed1i c\u00f9ng, m\u1edf\u00a0h\u1ed9p tho\u1ea1i\u00a0<em>Find and Replace <\/em>m\u1ed9t l\u1ea7n n\u1eefa \u0111\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c s\u1ef1 thay \u0111\u1ed5i, t\u1ee9c l\u00e0 thay th\u1ebf t\u1ea5t c\u1ea3 \u201cxxx\u201d b\u1eb1ng \u201c=\u201d \u0111\u1ec3 kh\u00f4i ph\u1ee5c li\u00ean k\u1ebft \u0111\u1ebfn c\u00e1c \u00f4 g\u1ed1c.\u00a0 \u0110\u00e3 xong!<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/transpose-linked-table.png\" alt=\"The table is transposed with all the cells linked to the original data.\" title=\"transpose-linked-table\"><\/p>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t gi\u1ea3i ph\u00e1p nhanh, nh\u1eb9 nh\u00e0ng v\u00e0 \u0111\u01a1n gi\u1ea3n, ph\u1ea3i kh\u00f4ng?\u00a0H\u1ea1n ch\u1ebf duy nh\u1ea5t c\u1ee7a c\u00e1ch n\u00e0y l\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a b\u1ea3ng ban \u0111\u1ea7u b\u1ecb m\u1ea5t trong qu\u00e1 tr\u00ecnh v\u00e0 b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i kh\u00f4i ph\u1ee5c l\u1ea1i n\u00f3 b\u1eb1ng tay (t\u00f4i s\u1ebd ch\u1ec9 cho b\u1ea1n m\u1ed9t c\u00e1ch nhanh ch\u00f3ng \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y trong h\u01b0\u1edbng d\u1eabn n\u00e0y).<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Chuyen_du_lieu_trong_Excel_bang_cong_thuc\"><\/span>Chuy\u1ec3n d\u1eef li\u1ec7u trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng t\u00ecm ki\u1ebfm c\u00e1c c\u00e1ch d\u1ec5 d\u00e0ng, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c c\u1ed9t th\u00e0nh h\u00e0ng trong b\u1ea3ng Excel c\u1ee7a b\u1ea1n v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chuyen_hang_sang_cot_trong_Excel_bang_ham_TRANSPOSE\"><\/span>Chuy\u1ec3n h\u00e0ng sang c\u1ed9t trong Excel b\u1eb1ng h\u00e0m TRANSPOSE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 t\u00ean g\u1ecdi c\u1ee7a n\u00f3, h\u00e0m Transpose \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u trong Excel.\u00a0N\u1ebfu b\u1ea1n kh\u00f4ng c\u00f3 nhi\u1ec1u kinh nghi\u1ec7m v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c Excel n\u00f3i chung, v\u00e0 c\u00e1c h\u00e0m array n\u00f3i ri\u00eang, h\u00e3y \u0111\u1ea3m b\u1ea3o b\u1ea1n tu\u00e2n th\u1ee7 \u0111\u00fang theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd chuy\u1ec3n \u0111\u1ed5i m\u1ed9t b\u1ea3ng li\u1ec7t k\u00ea c\u00e1c ti\u1ec3u bang Hoa K\u1ef3 theo d\u00e2n s\u1ed1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6371\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-171.png\" width=\"600\" height=\"133\" title=\"excel-dialog-box-launcher-1-171\"><\/p>\n<p>Tr\u01b0\u1edbc h\u1ebft, b\u1ea1n c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t trong b\u1ea3ng c\u1ee7a b\u1ea1n.\u00a0B\u1ea3ng m\u1eabu c\u1ee7a ch\u00fang ta c\u00f3 7 c\u1ed9t v\u00e0 6 h\u00e0ng, bao g\u1ed3m ti\u00eau \u0111\u1ec1.\u00a0H\u00e3y ghi nh\u1edb nh\u1eefng con s\u1ed1 n\u00e0y, v\u00e0 ch\u00fang ta h\u00e3y b\u1eaft \u0111\u1ea7u chuy\u1ec3n c\u00e1c h\u00e0ng.<\/p>\n<ol>\n<li>\u0110\u1ebfm c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i.\u00a0Trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ch\u00fang ta l\u00e0 7 c\u1ed9t v\u00e0 6 h\u00e0ng.<\/li>\n<li>Ch\u1ecdn m\u1ed9t ph\u1ea1m vi tr\u1ed1ng.\u00a0V\u00ec h\u00e0m TRANSPOSE chuy\u1ec3n h\u01b0\u1edbng d\u1ecdc v\u00e0 ngang c\u1ee7a m\u1ed9t d\u1ea3i \u00f4 \u0111\u00e3 ch\u1ecdn, b\u1ea1n c\u1ea7n ph\u1ea3i ch\u1ecdn m\u1ed9t v\u00f9ng c\u00f3 c\u00f9ng s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t nh\u01b0 b\u1ea3ng ngu\u1ed3n c\u1ee7a b\u1ea1n.\u00a0Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta \u0111ang ch\u1ecdn 6 c\u1ed9t v\u00e0 7 h\u00e0ng.<\/li>\n<li>Nh\u1ea5n\u00a0F2\u00a0\u0111\u1ec3 v\u00e0o ch\u1ebf \u0111\u1ed9 ch\u1ec9nh s\u1eeda.<\/li>\n<li>Vi\u1ebft h\u00e0m TRANSPOSE v\u00e0 nh\u1eadp d\u1ea3i d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i trong ngo\u1eb7c \u0111\u01a1n:\u00a0<strong>= TRANSPOSE (array).\u00a0<\/strong>Trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a n\u00e0y, ch\u00fang ta nh\u1eadp\u00a0<strong>=TRANSPOSE($A$1:$G$6)<\/strong>.<\/li>\n<\/ol>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0B\u1ea1n lu\u00f4n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng tham chi\u1ebfu\u00a0<strong>tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0trong h\u00e0m TRANSPOSE.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6372\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-172.png\" width=\"600\" height=\"133\" title=\"excel-dialog-box-launcher-1-172\"><\/p>\n<ol start=\"5\">\n<li>Nh\u1ea5n\u00a0Ctrl + Shift + Enter\u00a0.<\/li>\n<\/ol>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0B\u1ea1n c\u1ea7n nh\u1ea5n\u00a0Ctrl + Shift + Enter\u00a0v\u00ec \u0111\u00e2y l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, nh\u1ea5n\u00a0<em>Enter <\/em>\u00a0n\u00f3 s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/p>\n<p>\u0110\u00e3 xong!\u00a0D\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i v\u00e0 ch\u00fang ta c\u00f3 7 c\u1ed9t \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh 6 c\u1ed9t, ch\u00ednh x\u00e1c nh\u01b0 ch\u00fang ta mu\u1ed1n:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/table-transposed.png\" alt=\"The table is transposed and rows are converted to columns.\" title=\"table-transposed\"><\/p>\n<p><strong>\u01afu \u0111i\u1ec3m c\u1ee7a h\u00e0m TRANSPOSE:<\/strong><\/p>\n<p>L\u1ee3i \u00edch ch\u00ednh c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m TRANSPOSE l\u00e0 b\u1ea3ng \u0111\u01b0\u1ee3c chuy\u1ec3n gi\u1eef l\u1ea1i k\u1ebft n\u1ed1i v\u1edbi b\u1ea3ng ngu\u1ed3n v\u00e0 b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n thay \u0111\u1ed5i d\u1eef li\u1ec7u ngu\u1ed3n, b\u1ea3ng chuy\u1ec3n ti\u1ebfp c\u0169ng s\u1ebd thay \u0111\u1ed5i theo.<\/p>\n<p><strong>\u0110i\u1ec3m y\u1ebfu c\u1ee7a h\u00e0m TRANSPOSE:<\/strong><\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng b\u1ea3ng ban \u0111\u1ea7u kh\u00f4ng \u0111\u01b0\u1ee3c l\u01b0u trong b\u1ea3ng chuy\u1ec3n \u0111\u1ed5i, nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean.<\/li>\n<li>N\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 \u00f4 tr\u1ed1ng n\u00e0o trong b\u1ea3ng ngu\u1ed1n, c\u00e1c \u00f4 \u0111\u01b0\u1ee3c chuy\u1ec3n s\u1ebd ch\u1ee9a gi\u00e1 tr\u1ecb 0 thay th\u1ebf.<\/li>\n<li>B\u1ea1n kh\u00f4ng th\u1ec3 ch\u1ec9nh s\u1eeda b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i b\u1edfi v\u00ec h\u00e0m TRANSPOSE ph\u1ee5 thu\u1ed9c r\u1ea5t nhi\u1ec1u v\u00e0o d\u1eef li\u1ec7u ngu\u1ed3n.\u00a0N\u1ebfu b\u1ea1n c\u1ed1 g\u1eafng thay \u0111\u1ed5i gi\u00e1 tr\u1ecb c\u1ee7a \u00f4, Excel s\u1ebd b\u00e1o l\u1ed7i \u201cYou cannot change part of an array\u201d [B\u1ea1n kh\u00f4ng th\u1ec3 thay \u0111\u1ed5i m\u1ed9t ph\u1ea7n c\u1ee7a m\u1ea3ng].<\/li>\n<\/ul>\n<p>Th\u00eam v\u00e0o \u0111\u00f3, d\u00f9 h\u00e0m TRANSPOSE t\u1ed1t v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng, nh\u01b0ng ch\u1eafc ch\u1eafn n\u00f3 thi\u1ebfu t\u00ednh linh ho\u1ea1t v\u00e0 do \u0111\u00f3 c\u00f3 th\u1ec3 kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 s\u1eed d\u1ee5ng trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chuyen_Hang_thanh_cot_cot_thanh_hang_bang_cach_su_dung_Ham_INDIRECT\"><\/span>Chuy\u1ec3n H\u00e0ng th\u00e0nh c\u1ed9t \/ c\u1ed9t th\u00e0nh h\u00e0ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng H\u00e0m INDIRECT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ph\u01b0\u01a1ng ph\u00e1p chuy\u1ec3n \u0111\u1ed5i c\u1ed9t sang h\u00e0ng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i n\u00e0y kh\u00e1 gi\u1ed1ng v\u1edbi c\u00e1ch tr\u01b0\u1edbc \u0111\u00f3. \u0110i\u1ec3m m\u1ea1nh ch\u00ednh c\u1ee7a n\u00f3 \u01b0u vi\u1ec7t h\u01a1n h\u00e0m Transpose l\u00e0 n\u00f3 cho ph\u00e9p ch\u1ec9nh s\u1eeda \u0111\u01b0\u1ee3c trong b\u1ea3ng chuy\u1ec3n \u0111\u1ed5i, \u0111\u1ed3ng th\u1eddi gi\u1eef k\u1ebft n\u1ed1i v\u1edbi b\u1ea3ng ban \u0111\u1ea7u.<\/p>\n<p>Ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng m\u1ed9t b\u1ea3ng nh\u1ecf trong v\u00ed d\u1ee5 n\u00e0y \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 t\u1eadp trung v\u00e0o qu\u00e1 tr\u00ecnh chuy\u1ec3n ch\u1ee9 kh\u00f4ng ph\u1ea3i tr\u00ean d\u1eef li\u1ec7u b\u1edfi v\u00ec ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m INDIRECT<\/a> v\u00e0 ADDRESS, s\u1ebd h\u01a1i ph\u1ee9c t\u1ea1p m\u1ed9t ch\u00fat.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 d\u1eef li\u1ec7u trong 4 c\u1ed9t (A \u2013 D) v\u00e0 5 h\u00e0ng (1 \u2013 5):<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/transpose-table-indirect.png\" alt=\"Rows to be converted to columns using INDIRECT function\" title=\"transpose-table-indirect\"><\/p>\n<ol>\n<li>Nh\u1eadp c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y v\u00e0o \u00f4 b\u00ean tr\u00e1i c\u1ee7a v\u00f9ng ch\u1ecdn, gi\u1ea3 s\u1eed l\u00e0 \u00f4 A7 v\u00e0 nh\u1ea5n ph\u00edm\u00a0<em>Enter<\/em>:<\/li>\n<\/ol>\n<p><strong>=INDIRECT(ADDRESS(COLUMN(A1),ROW(A1)))<\/strong><\/p>\n<p>N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n b\u1eaft \u0111\u1ea7u \u1edf m\u1ed9t h\u00e0ng kh\u00e1c v\u1edbi 1 v\u00e0 c\u1ed9t kh\u00e1c v\u1edbi A, b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n m\u1ed9t ch\u00fat:<\/p>\n<p><strong>=INDIRECT(ADDRESS(COLUMN(A1) \u2013 COLUMN($A$1) + ROW($A$1), ROW(A1) \u2013 ROW($A$1) + COLUMN($A$1)))<\/strong><\/p>\n<p>Tr\u01b0\u1eddng h\u1ee3p A1 l\u00e0 \u00f4 tr\u00ean c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a b\u1ea3ng ngu\u1ed3n c\u1ee7a b\u1ea1n.\u00a0Ngo\u00e0i ra, xin l\u01b0u \u00fd vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i.<\/p>\n<ol start=\"2\">\n<li>Sao ch\u00e9p c\u00f4ng th\u1ee9c qua m\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1eb7t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c chuy\u1ec3n nh\u01b0 th\u01b0\u1eddng l\u1ec7 b\u1eb1ng c\u00e1ch k\u00e9o m\u1ed9t ch\u1eef th\u1eadp m\u00e0u \u0111en nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4 \u0111\u00e3 ch\u1ecdn.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/indirect-function.png\" alt=\"Copy the formula through the range where you want to put the transposed data.\" title=\"indirect-function\"><\/p>\n<p>\u0110\u01b0\u1ee3c r\u1ed1i \u0111\u1ea5y!\u00a0Trong b\u1ea3ng m\u1edbi t\u1ea1o c\u1ee7a b\u1ea1n, t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c chuy\u1ec3n sang h\u00e0ng.<\/p>\n<p>Tuy nhi\u00ean, c\u00e1c \u00f4 \u0111\u01b0\u1ee3c chuy\u1ec3n tr\u00f4ng r\u1ea5t m\u1ed9c m\u1ea1c v\u00e0 ng\u00f4 ngh\u00ea so v\u1edbi d\u1eef li\u1ec7u ban \u0111\u1ea7u.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rows-columns-indirect.png\" alt=\"The formatting of transposed data is lost.\" title=\"rows-columns-indirect\"><\/p>\n<p>Nh\u01b0ng \u0111\u1eebng th\u1ea5t v\u1ecdng, \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t v\u1ea5n \u0111\u1ec1 g\u00ec l\u1edbn c\u1ea3.\u00a0B\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng kh\u00f4i ph\u1ee5c l\u1ea1i \u0111\u1ecbnh d\u1ea1ng ngu\u1ed3n theo c\u00e1ch n\u00e0y:<\/p>\n<ul>\n<li>Sao ch\u00e9p b\u1ea3ng ban \u0111\u1ea7u;<\/li>\n<li>Ch\u1ecdn b\u1ea3ng chuy\u1ec3n \u0111\u1ed5i;<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea3ng chuy\u1ec3n \u0111\u1ed5i v\u00e0 ch\u1ecdn\u00a0<strong>Formatting\u00a0<\/strong>d\u01b0\u1edbi<strong>\u00a0Paste Options.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6373\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-173.png\" width=\"600\" height=\"322\" title=\"excel-dialog-box-launcher-1-173\"><\/p>\n<p>T\u00f3m l\u1ea1i, INDIRECT\u00a0 d\u01b0\u1eddng nh\u01b0 l\u00e0 m\u1ed9t c\u00e1ch linh ho\u1ea1t h\u01a1n \u0111\u1ec3 bi\u1ebfn h\u00e0ng th\u00e0nh c\u1ed9t trong Excel so v\u1edbi h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-transpose-chuyen-doi-hang-thanh-cot-cot-thanh-hang-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">TRANSPOSE<\/a>.<\/p>\n<p><strong>\u01afu \u0111i\u1ec3m<\/strong>\u00a0: b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng ch\u1ec9nh s\u1eeda b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng chuy\u1ec3n ti\u1ebfp, \u0111\u1ed3ng th\u1eddi gi\u1eef li\u00ean k\u1ebft v\u1edbi b\u1ea3ng ban \u0111\u1ea7u v\u00e0 c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n th\u1ef1c hi\u1ec7n thay \u0111\u1ed5i d\u1eef li\u1ec7u ngu\u1ed3n.<\/p>\n<p><strong>Nh\u1eefng h\u1ea1n ch\u1ebf<\/strong>\u00a0: tr\u00ean th\u1ef1c t\u1ebf, t\u00f4i ch\u1ec9 c\u00f3 th\u1ec3 th\u1ea5y m\u1ed9t \u0111i\u1ec3m \u2013 vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u kh\u00f4ng \u0111\u01b0\u1ee3c l\u01b0u.\u00a0M\u1eb7c d\u00f9, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng kh\u00f4i ph\u1ee5c n\u00f3, nh\u01b0 v\u00ed d\u1ee5 \u1edf tr\u00ean.<\/p>\n<p>B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 c\u00f3 c\u1ea3m gi\u00e1c nh\u01b0 th\u1ebf n\u00e0o v\u1ec1 h\u00e0m\u00a0 INDIRECT, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n c\u00f3 c\u00e1i nh\u00ecn s\u00e2u h\u01a1n v\u1ec1 nh\u1eefng g\u00ec c\u00f4ng th\u1ee9c th\u1ef1c s\u1ef1 \u0111ang l\u00e0m v\u00e0 t\u1ea1i sao ch\u00fang ta l\u1ea1i s\u1eed d\u1ee5ng n\u00f3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m ADDRESS.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_INDIRECT_va_ADDRESS_%E2%80%93_cu_phap_va_logic\"><\/span>H\u00e0m INDIRECT v\u00e0 ADDRESS \u2013 c\u00fa ph\u00e1p v\u00e0 logic<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m INDIRECT, nh\u01b0 t\u00ean c\u1ee7a n\u00f3, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 gi\u00e1n ti\u1ebfp tham kh\u1ea3o m\u1ed9t \u00f4.\u00a0V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 B1 trong \u00f4 A8, th\u00ec b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y trong A8\u00a0<strong>=INDIRECT(\u201cB1\u201d)<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/indirect-function-syntax.png\" alt=\"The syntax of the INDIRECT function\" title=\"indirect-function-syntax\"><br \/>\nNh\u01b0ng s\u1ee9c m\u1ea1nh th\u1ef1c c\u1ee7a h\u00e0m INDIRECT l\u00e0 n\u00f3 c\u00f3 th\u1ec3 bi\u1ebfn b\u1ea5t k\u1ef3 chu\u1ed7i n\u00e0o th\u00e0nh tham chi\u1ebfu, bao g\u1ed3m m\u1ed9t chu\u1ed7i m\u00e0 b\u1ea1n x\u00e2y d\u1ef1ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4 kh\u00e1c.\u00a0V\u00e0 \u0111\u00e2y ch\u00ednh x\u00e1c l\u00e0 \u0111i\u1ec1u ch\u00fang ta s\u1ebd l\u00e0m ti\u1ebfp theo.\u00a0N\u1ebfu b\u1ea1n theo d\u00f5i ph\u1ea7n n\u00e0y, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng hi\u1ec3u t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n c\u00f2n l\u1ea1i:)<\/p>\n<p>Nh\u01b0 \u0111\u00e3 bi\u1ebft, ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng 3 h\u00e0m n\u1eefa trong c\u00f4ng th\u1ee9c l\u00e0 \u2013 ADDRESS, COLUMN v\u00e0 ROW.<\/p>\n<p>H\u00e0m ADDRESS \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ea5y \u0111\u1ecba ch\u1ec9 c\u1ee7a m\u1ed9t \u00f4 theo s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.\u00a0H\u00e3y nh\u1edb \u0111i\u1ec1u n\u00e0y: \u0111\u1ea7u ti\u00ean, h\u00e0ng, c\u1ed9t th\u1ee9 hai.\u00a0V\u00ed d\u1ee5: ADDRESS (8,1) tr\u1ea3 v\u1ec1 $ A $ 8.<\/p>\n<p>H\u00e0m COLUMN tr\u1ea3 v\u1ec1 s\u1ed1 c\u1ed9t c\u1ee7a tham chi\u1ebfu \u00f4 \u0111\u00e3 cho.\u00a0V\u00ed d\u1ee5,\u00a0<strong>=COLUMN(A3) <\/strong>tr\u1ea3 v\u1ec1 1, b\u1edfi v\u00ec c\u1ed9t A l\u00e0 c\u1ed9t th\u1ee9 nh\u1ea5t.\u00a0Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111o\u00e1n \u0111\u01b0\u1ee3c, h\u00e0m ROW ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c h\u00e0ng.<\/p>\n<p>V\u00e0 b\u00e2y gi\u1edd, h\u00e3y \u0111\u1ec3 t\u00f4i nh\u1eafc b\u1ea1n v\u1ec1 to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c m\u00e0 ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u00e1c c\u1ed9t trong b\u1ea3ng t\u00ednh Excel c\u1ee7a ch\u00fang ta:\u00a0<strong>=INDIRECT(ADDRESS(COLUMN(A1),ROW(A1)))<\/strong><\/p>\n<p>Nh\u01b0 b\u1ea1n th\u1ea5y, trong h\u00e0m ADDRESS, ch\u00fang ta ch\u1ec9 \u0111\u1ecbnh COLUMN (A1) v\u00e0 ROW (A1),v\u00e0 \u0111\u00e2y th\u1ef1c s\u1ef1 l\u00e0 m\u1ed9t m\u01b0u m\u1eb9o!\u00a0H\u00e3y nh\u1edb r\u1eb1ng, h\u00e0m ADDRESS di\u1ec5n gi\u1ea3i s\u1ed1 \u0111\u1ea7u ti\u00ean d\u01b0\u1edbi d\u1ea1ng h\u00e0ng v\u00e0 th\u1ee9 hai l\u00e0 c\u1ed9t.\u00a0N\u00f3i c\u00e1ch kh\u00e1c, h\u00e0m ADDRESS l\u1ea5y m\u1ed9t c\u1ed9t \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i b\u1edfi h\u00e0m COLUMN v\u00e0 thay \u0111\u1ed5i n\u00f3 th\u00e0nh m\u1ed9t h\u00e0ng, sau \u0111\u00f3 l\u1ea5y m\u1ed9t h\u00e0ng v\u00e0 chuy\u1ec3n n\u00f3 sang c\u1ed9t, t\u1ee9c l\u00e0 ho\u00e1n \u0111\u1ed5i c\u00e1c h\u00e0ng th\u00e0nh c\u00e1c c\u1ed9t.<\/p>\n<p>H\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/su-khac-nhau-giua-ham-columns-va-ham-column-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">COLUMN<\/a> v\u00e0 ROW tr\u1ea3 l\u1ea1i s\u1ed1 c\u1ed9t v\u00e0 s\u1ed1 h\u00e0ng, t\u01b0\u01a1ng \u1ee9ng -&gt; H\u00e0m ADDRESS chuy\u1ec3n \u0111\u1ed5i c\u1ed9t sang h\u00e0ng v\u00e0 h\u00e0ng sang c\u1ed9t -&gt; H\u00e0m INDIRECT xu\u1ea5t ra d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c xoay sang d\u1eef li\u1ec7u kh\u00e1c \u00a0trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n.\u00a0Kh\u00f4ng c\u00f3 g\u00ec gh\u00ea g\u1edbm c\u1ea3 \u0111\u00fang kh\u00f4ng?<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-295.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7388,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7387","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\/7387","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=7387"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7387\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7388"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}