{"id":2225,"date":"2023-07-23T04:40:51","date_gmt":"2023-07-23T04:40:51","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/"},"modified":"2023-07-23T04:40:51","modified_gmt":"2023-07-23T04:40:51","slug":"google-sheet-menggabungkan-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/","title":{"rendered":"Cara menggabungkan kolom di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan salah satu metode berikut untuk menggabungkan beberapa kolom menjadi satu kolom di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gabungkan Kolom dengan &amp; Operator<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span> <span dir=\"auto\" style=\"color: #800080;\">B1<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gabungkan Kolom dengan Operator &amp; dan Pemisah di Antaranya<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">&amp; <span style=\"color: #008000;\">\"-\"<\/span> &amp;<\/span> <span dir=\"auto\" style=\"color: #800080;\">B1\n\n<span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">&amp; <span style=\"color: #008000;\">\" \"<\/span> &amp;<\/span> B1\n\n<span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">&amp; <span style=\"color: #008000;\">\"_\"<\/span> &amp;<\/span> B1\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 1: Gabungkan Kolom dengan &amp; Operator<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20378 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/combiner1.png\" alt=\"\" width=\"569\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menggabungkan nilai dari kolom A dan kolom B ke dalam kolom baru:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span> <span dir=\"auto\" style=\"color: #800080;\">B2<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20379 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/combiner2.png\" alt=\"\" width=\"672\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita bisa menggunakan rumus yang sama untuk menggabungkan kolom sebanyak yang kita inginkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, rumus berikut dapat digunakan untuk menggabungkan nilai pada kolom Tim, Konferensi, dan Poin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-20380 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/combiner3.png\" alt=\"\" width=\"676\" height=\"369\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 2: Gabungkan Kolom dengan Operator &amp; dan Pemisah<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menggabungkan nilai dari kolom A dan kolom B menjadi kolom baru dengan spasi di antara nilainya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">&amp; <span style=\"color: #008000;\">\" \"<\/span> &amp;<\/span> <span dir=\"auto\" style=\"color: #800080;\">B2<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20384 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/combiner4-1.png\" alt=\"\" width=\"670\" height=\"387\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita dapat menggunakan pemisah apa pun yang kita inginkan. Misalnya, kita juga bisa menggunakan tanda hubung untuk memisahkan nilai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20385 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/combiner5-1.png\" alt=\"\" width=\"675\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan outlier di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah kemunculan di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-google-sheet-berdasarkan-kategori\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan nilai berdasarkan kategori di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan salah satu metode berikut untuk menggabungkan beberapa kolom menjadi satu kolom di Google Spreadsheet: Metode 1: Gabungkan Kolom dengan &amp; Operator = A1 &amp; B1 Metode 2: Gabungkan Kolom dengan Operator &amp; dan Pemisah di Antaranya = A1 &amp; &#8220;-&#8221; &amp; B1 = A1 &amp; &#8221; &#8221; &amp; B1 = A1 &amp; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menggabungkan Kolom di Google Sheets (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan beberapa kolom menjadi satu di Google Sheets, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggabungkan Kolom di Google Sheets (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan beberapa kolom menjadi satu di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T04:40:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/combiner1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/\",\"name\":\"Cara Menggabungkan Kolom di Google Sheets (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T04:40:51+00:00\",\"dateModified\":\"2023-07-23T04:40:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan beberapa kolom menjadi satu di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggabungkan kolom di google sheets (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menggabungkan Kolom di Google Sheets (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggabungkan beberapa kolom menjadi satu di Google Sheets, dengan beberapa contoh.","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:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggabungkan Kolom di Google Sheets (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggabungkan beberapa kolom menjadi satu di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-23T04:40:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/combiner1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/","url":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/","name":"Cara Menggabungkan Kolom di Google Sheets (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T04:40:51+00:00","dateModified":"2023-07-23T04:40:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan beberapa kolom menjadi satu di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggabungkan kolom di google sheets (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2225"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2225"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2225\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}