{"id":4225,"date":"2023-07-12T17:23:23","date_gmt":"2023-07-12T17:23:23","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/"},"modified":"2023-07-12T17:23:23","modified_gmt":"2023-07-12T17:23:23","slug":"google-sheet-kiri-bergabung","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/","title":{"rendered":"Cara meninggalkan gabung di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Gabungan kiri<\/strong> memungkinkan Anda menggabungkan dua tabel yang setiap baris pada tabel kiri disimpan dan hanya baris yang memiliki nilai yang cocok pada kolom tertentu pada tabel kanan yang disimpan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi <strong>VLOOKUP<\/strong> untuk melakukan penggabungan kiri di Google Spreadsheet.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nilai untuk setiap tabel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai berikut untuk dua tabel di Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33426 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl1.jpg\" alt=\"\" width=\"669\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan melakukan penggabungan kiri di mana kami akan menyimpan semua baris dari tabel kiri dan hanya menggabungkan baris dari tabel kanan yang memiliki nilai yang cocok di kolom <strong>Tim<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat salinan tabel pertama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, salin dan tempel nilai dari tabel pertama ke dalam rentang sel baru:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33427 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl2.jpg\" alt=\"\" width=\"665\" height=\"523\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Lakukan gabung kiri menggunakan VLOOKUP<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan mengetikkan rumus berikut di sel <strong>C13<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=ArrayFormula(VLOOKUP( <span style=\"color: #ff6600;\">A2<\/span> , <span style=\"color: #800080;\">$E$2:$G$9<\/span> , {2,3}, <span style=\"color: #3366ff;\">FALSE<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-33428\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl3.jpg\" alt=\"bergabunglah di kiri di Google Spreadsheet\" width=\"676\" height=\"558\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan juga header kolom <strong>Assists<\/strong> dan <strong>Rebounds<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33429 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl4.jpg\" alt=\"\" width=\"654\" height=\"523\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Gabungan kiri sekarang selesai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setiap baris di tabel kiri disimpan dan hanya baris dengan nama tim yang cocok di tabel kanan yang disimpan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tim tertentu tidak mempunyai permainan pada tabel di sebelah kanan, maka nilai <strong>#N\/A<\/strong> ditampilkan untuk kolom Assist dan Rebound.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Mavs ada pada tabel di sebelah kanan, sehingga mereka memiliki nilai assist dan rebound yang sesuai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Warriors tidak berada di braket kanan, jadi mereka memiliki <strong>#N\/A<\/strong> untuk assist dan rebound.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tiga-kolom\/\" target=\"_blank\" rel=\"noopener\">Bagaimana membandingkan tiga kolom di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan duplikat dalam dua kolom di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-teratas-10-persen\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan nilai 10% teratas di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gabungan kiri memungkinkan Anda menggabungkan dua tabel yang setiap baris pada tabel kiri disimpan dan hanya baris yang memiliki nilai yang cocok pada kolom tertentu pada tabel kanan yang disimpan. Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi VLOOKUP untuk melakukan penggabungan kiri di Google Spreadsheet. Langkah 1: Masukkan nilai untuk setiap tabel Mari [&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 Kiri Bergabung di Google Sheets \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan gabung kiri di Google Sheets, dengan contoh langkah demi langkah.\" \/>\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-kiri-bergabung\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Kiri Bergabung di Google Sheets \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan gabung kiri di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T17:23:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl1.jpg\" \/>\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-kiri-bergabung\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/\",\"name\":\"Cara Kiri Bergabung di Google Sheets \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T17:23:23+00:00\",\"dateModified\":\"2023-07-12T17:23:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan gabung kiri di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara meninggalkan gabung di google spreadsheet\"}]},{\"@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 Kiri Bergabung di Google Sheets \u2013 Statorial","description":"Tutorial ini menjelaskan cara melakukan gabung kiri di Google Sheets, dengan contoh langkah demi langkah.","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-kiri-bergabung\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Kiri Bergabung di Google Sheets \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara melakukan gabung kiri di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/","og_site_name":"Statorials","article_published_time":"2023-07-12T17:23:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl1.jpg"}],"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-kiri-bergabung\/","url":"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/","name":"Cara Kiri Bergabung di Google Sheets \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T17:23:23+00:00","dateModified":"2023-07-12T17:23:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan gabung kiri di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-kiri-bergabung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara meninggalkan gabung di google spreadsheet"}]},{"@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\/4225"}],"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=4225"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4225\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}