{"id":12391,"date":"2025-01-15T08:28:47","date_gmt":"2025-01-15T08:28:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/chuyen-doi-du-lieu-tu-hang-sang-cot-hoac-nguoc-lai-trong-excel\/"},"modified":"2025-01-15T08:28:47","modified_gmt":"2025-01-15T08:28:47","slug":"chuyen-doi-du-lieu-tu-hang-sang-cot-hoac-nguoc-lai-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/chuyen-doi-du-lieu-tu-hang-sang-cot-hoac-nguoc-lai-trong-excel\/","title":{"rendered":"Chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u t\u1eeb h\u00e0ng sang c\u1ed9t ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i trong excel"},"content":{"rendered":"
\n

Trong khi l\u00e0m vi\u1ec7c v\u1edbi Excel, n\u1ebfu trang t\u00ednh c\u1ee7a b\u1ea1n c\u00f3 d\u1eef li\u1ec7u theo c\u1ed9t m\u00e0 mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i n\u00f3 v\u00e0 s\u1eafp x\u1ebfp l\u1ea1i theo h\u00e0ng th\u00ec c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng ho\u00e1n \u0111\u1ed5i . N\u00f3 cho ph\u00e9p b\u1ea1n nhanh ch\u00f3ng chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u t\u1eeb c\u1ed9t sang h\u00e0ng, ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i.<\/strong><\/em><\/p>\n

Ch\u1eb3ng h\u1ea1n, d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u00e0 nh\u01b0 sau:<\/p>\n

<\/p>\n

Mu\u1ed1n chuy\u1ec3n d\u1eef li\u1ec7u theo h\u00e0ng, b\u1ea1n\u00a0ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ea7n s\u1eafp x\u1ebfp l\u1ea1i v\u00e0 nh\u1ea5n Ctrl+C<\/strong>. T\u1ea1i v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n Paste d\u1eef li\u1ec7u, nh\u1ea5p chu\u1ed9t ph\u1ea3i \u00a0r\u1ed3i ch\u1ecdn c\u00f4ng c\u1ee5 ho\u00e1n \u0111\u1ed5i c\u00f3 h\u00ecnh \u1ea3nh d\u1ea1ng n\u00e0y: \u00a0\"\u1ea2nh\u00a0.<\/p>\n

<\/p>\n

V\u00e0 k\u1ebft qu\u1ea3:<\/p>\n

<\/p>\n

Th\u1ebf l\u00e0 xong r\u1ed3i \u0111\u1ea5y.<\/p>\n

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

N\u1ebfu b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i ng\u01b0\u1ee3c l\u1ea1i th\u00ec l\u00e0m t\u01b0\u01a1ng t\u1ef1 nh\u00e9!<\/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":12392,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12391","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\/12391","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=12391"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12392"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}