{"id":12227,"date":"2025-01-15T07:41:34","date_gmt":"2025-01-15T07:41:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-ham-transpose-chuyen-doi-hang-thanh-cot-cot-thanh-hang-trong-excel\/"},"modified":"2025-01-15T07:41:34","modified_gmt":"2025-01-15T07:41:34","slug":"huong-dan-su-dung-ham-transpose-chuyen-doi-hang-thanh-cot-cot-thanh-hang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-ham-transpose-chuyen-doi-hang-thanh-cot-cot-thanh-hang-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Transpose chuy\u1ec3n \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u1ed9t, c\u1ed9t th\u00e0nh h\u00e0ng trong Excel."},"content":{"rendered":"
\n

H\u00e0m TRANSPOSE<\/strong>\u00a0trong Excel c\u00f3 ch\u1ee9c n\u0103ng chuy\u1ec3n \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u1ed9t, c\u1ed9t th\u00e0nh h\u00e0ng c\u1ee7a m\u1ea1ng array ho\u1eb7c c\u1ee7a m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n

C\u00fa ph\u00e1p h\u00e0m\u00a0TRANSPOSE: TRANSPOSE(array)<\/strong><\/p>\n

V\u00ed d\u1ee5:<\/strong> Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n

<\/p>\n

\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u1ed9t th\u00e0nh h\u00e0ng, c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n nh\u01b0 sau:
\nB\u01b0\u1edbc 1:<\/strong> C\u00e1c b\u1ea1n h\u00e3y \u0111\u00e1nh d\u1ea5u m\u1ed9t v\u00f9ng c\u00f3 3 h\u00e0ng v\u00e0 6 c\u1ed9t (v\u00ed d\u1ee5: A8:F10)<\/p>\n

<\/p>\n

B\u01b0\u1edbc 2:<\/strong> T\u00ecm h\u00e0m Transpose ho\u1eb7c g\u00f5 t\u1eeb b\u00e0n ph\u00edm: =Transpose(A1:C6)<\/strong><\/p>\n

<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n Ctrl+Shift+Enter.<\/strong><\/p>\n

\u2192 K\u1ebft qu\u1ea3:<\/p>\n

<\/p>\n

Nh\u1eefng thao t\u00e1c n\u00e0y tuy r\u1ea5t \u0111\u01a1n gi\u1ea3n, nh\u01b0ng n\u1ebfu kh\u00f4ng bi\u1ebft s\u1eed d\u1ee5ng ho\u1eb7c ch\u01b0a t\u1eebng s\u1eed d\u1ee5ng, b\u1ea1n s\u1ebd m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c khi x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u tr\u00ean Excel.\u00a0\u00a0To\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\u00a0EX101 \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: HocExcel.Online<\/a><\/p>\n

\u00a0<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12228,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12227","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12227","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=12227"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12227\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12228"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}