{"id":1820,"date":"2023-11-02T03:59:47","date_gmt":"2023-11-02T03:59:47","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/"},"modified":"2023-12-06T06:18:14","modified_gmt":"2023-12-06T06:18:14","slug":"kolom-ke-baris","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/","title":{"rendered":"Bagaimana cara mengubah kolom dalam baris (sebaliknya)?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1881382796\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Excel, jika ingin mengubah kolom menjadi baris, Anda bisa menggunakan fungsi TRANSPOSE. Dengan fungsi ini, yang perlu Anda lakukan hanyalah memilih rentang dengan sel setara tempat Anda ingin menambahkan data yang diubah, merujuk ke rentang tersebut dan menggunakan CONTROL + SHIFT + ENTER.<\/p><p> Dalam contoh berikut, Anda memiliki daftar nama dan usia. Dan kita perlu mengubah dua kolom ini menjadi baris. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67607\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\" sizes=\"auto, \" srcset=\"\" alt=\"daftar-nama-dan-umur\" width=\"315\" height=\"324\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah mengubah kolom menjadi baris<\/h2><ol type=\"1\"><li> Pertama, pada rentang D1:H2, masukkan fungsi TRANSPOSE.<\/li><li> Kemudian lihat rentang A1:B6.<\/li><li> Setelah itu, ketikkan tanda kurung penutup.<\/li><li> Terakhir, tekan dan tahan CRTL + SHIFT dan tekan ENTER. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67608\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-colonnes-de-fonction-de-transposition-en-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengubah urutan-fungsi-kolom-ke-baris\" width=\"584\" height=\"298\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TRANSPOSE(A1:B6)<\/code><\/pre><p> Seperti yang Anda lihat pada contoh di atas, kami telah berhasil mengubah kolom menjadi baris.<\/p><p> Untuk memahami cara kerja fungsi transpose, Anda perlu memahami bahwa fungsi ini mengambil array (rentang) yang Anda tentukan dan kemudian mengubah sel vertikal menjadi sel horizontal dan sebaliknya.<\/p><p> Namun ada satu hal yang perlu Anda perhatikan, Anda perlu memilih jumlah sel yang sama dengan cara yang berlawanan. Dan Anda perlu menggunakan <strong>CONTROL + SHIFT + ENTER<\/strong> agar fungsi ini berfungsi.<\/p><p> Satu hal lagi, setelah Anda membuat TRANSPOSE bekerja secara dinamis, setelah Anda mengubah nilai di salah satu sel dari sel asli, nilai tersebut juga akan diubah dalam rentang yang dialihkan.<\/p><p> Dan jika Anda ingin mengubah rentang yang dialihkan menjadi nilai dan tidak ingin menghubungkannya dengan nilai aslinya, Anda dapat menggunakan tempel nilai khusus, atau memilih rentang menggunakan pintasan keyboard Ctrl + C lalu Alt + V \u21e2 V. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/changer-les-colonnes-en-lignes.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggunakan-huruf-kapital-pada-huruf-pertama\/\">Gunakan huruf besar pada huruf pertama di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kasus-kalimat\/\">Beralih ke Kasus Kalimat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/\">Kembalikan nama depan dan belakang dan tambahkan perintah<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/\">Mengubah huruf besar\/kecil (huruf besar, huruf kecil, benar)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1820","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara mengubah kolom ke baris (dan sebaliknya) di Excel?<\/title>\n<meta name=\"description\" content=\"Pada rumus ini, Anda akan mempelajari cara menggunakan rumus untuk mengubah data dari kolom menjadi baris di Excel dengan cara yang mudah.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengubah kolom ke baris (dan sebaliknya) di Excel?\" \/>\n<meta property=\"og:description\" content=\"Pada rumus ini, Anda akan mempelajari cara menggunakan rumus untuk mengubah data dari kolom menjadi baris di Excel dengan cara yang mudah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/\",\"name\":\"Bagaimana cara mengubah kolom ke baris (dan sebaliknya) di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\",\"datePublished\":\"2023-11-02T03:59:47+00:00\",\"dateModified\":\"2023-12-06T06:18:14+00:00\",\"description\":\"Pada rumus ini, Anda akan mempelajari cara menggunakan rumus untuk mengubah data dari kolom menjadi baris di Excel dengan cara yang mudah.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengubah kolom dalam baris (sebaliknya)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara mengubah kolom ke baris (dan sebaliknya) di Excel?","description":"Pada rumus ini, Anda akan mempelajari cara menggunakan rumus untuk mengubah data dari kolom menjadi baris di Excel dengan cara yang mudah.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengubah kolom ke baris (dan sebaliknya) di Excel?","og_description":"Pada rumus ini, Anda akan mempelajari cara menggunakan rumus untuk mengubah data dari kolom menjadi baris di Excel dengan cara yang mudah.","og_url":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:14+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/","url":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/","name":"Bagaimana cara mengubah kolom ke baris (dan sebaliknya) di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png","datePublished":"2023-11-02T03:59:47+00:00","dateModified":"2023-12-06T06:18:14+00:00","description":"Pada rumus ini, Anda akan mempelajari cara menggunakan rumus untuk mengubah data dari kolom menjadi baris di Excel dengan cara yang mudah.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengubah kolom dalam baris (sebaliknya)?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1820"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1820\/revisions"}],"predecessor-version":[{"id":2699,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1820\/revisions\/2699"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}