{"id":4613,"date":"2023-07-09T15:20:47","date_gmt":"2023-07-09T15:20:47","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/"},"modified":"2023-07-09T15:20:47","modified_gmt":"2023-07-09T15:20:47","slug":"google-sheet-digabungkan-dengan-baris-baru","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/","title":{"rendered":"Google spreadsheet: menggabungkan sel dengan jeda baris"},"content":{"rendered":"

<\/p>\n

\n

Ada dua cara untuk menggabungkan sel dengan pemisah baris di Google Spreadsheet:<\/span><\/p>\n

Metode 1: Gunakan CONCATENATE()<\/strong><\/span><\/p>\n

 =<\/span> CONCATENATE<\/span> (<\/span> A1<\/span> ,<\/span> CHAR<\/span> (<\/span> 10<\/span> )<\/span> ,<\/span> A2<\/span> )<\/span>\n<\/strong><\/pre>\n
 Metode 2: Gunakan TEXTJOIN()<\/strong><\/span><\/p>\n
 =<\/span> TEXTJOIN<\/span> (<\/span> CHAR<\/span> (<\/span> 10<\/span> )<\/span> ,<\/span> TRUE<\/span> ,<\/span> A1:A2<\/span> )<\/span><\/strong><\/pre>\n
 Kedua rumus tersebut akan menggabungkan nilai di sel A1<\/strong> dan A2<\/strong> dengan jeda baris.<\/span><\/p>\n
 Catatan<\/strong> : Di Google Sheets, CHAR(10)<\/strong> digunakan untuk mewakili jeda baris.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan dua sel berikut di Google Spreadsheet:<\/span> <\/p>\n
\"\"<\/p>\n
 Contoh 1: Gunakan CONCATENATE() untuk menggabungkan dengan baris baru di Google Spreadsheet<\/strong><\/span><\/h2>\n
 Kita bisa mengetikkan rumus berikut di sel C1<\/strong> untuk menggabungkan string di sel A1<\/strong> dan A2<\/strong> menggunakan baris baru:<\/span><\/p>\n
 =<\/span> CONCATENATE<\/span> (<\/span> A1<\/span> ,<\/span> CHAR<\/span> (<\/span> 10<\/span> )<\/span> ,<\/span> A2<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Google<\/p>\n
 Perhatikan bahwa string di sel A1<\/strong> dan A2<\/strong> telah digabungkan dengan baris baru.<\/span><\/p>\n
 Contoh 2: Gunakan TEXTJOIN() untuk menggabungkan jeda baris di Google Spreadsheet<\/strong><\/span><\/h2>\n
 Kita bisa mengetikkan rumus berikut di sel C1<\/strong> untuk menggabungkan string di sel A1<\/strong> dan A2<\/strong> menggunakan baris baru:<\/span><\/p>\n
 =<\/span> TEXTJOIN<\/span> (<\/span> CHAR<\/span> (<\/span> 10<\/span> )<\/span> ,<\/span> TRUE<\/span> ,<\/span> A1:A2<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa string di sel A1<\/strong> dan A2<\/strong> telah digabungkan dengan baris baru.<\/span><\/p>\n
 Catatan<\/strong> : Argumen TRUE<\/strong> menetapkan bahwa sel kosong harus diabaikan.<\/span><\/p>\n
 Metode ini sangat berguna ketika Anda memiliki banyak sel untuk digabungkan dengan jeda baris.<\/span><\/p>\n
 Misalnya, tangkapan layar berikut menunjukkan cara menggunakan fungsi TEXTJOIN()<\/strong> untuk menggabungkan setiap sel dalam rentang A1:A5<\/strong> dengan jeda baris:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa setiap sel dalam rentang tersebut telah digabungkan menjadi satu sel dengan jeda baris.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
Google Spreadsheet: Cara menggunakan rumus penggabungan If<\/a>
 Google Sheets: Cara menggunakan CONCATENATE dengan spasi<\/a>
 Google Spreadsheet: cara menggunakan CONCAT dengan QUERY<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Ada dua cara untuk menggabungkan sel dengan pemisah baris di Google Spreadsheet: Metode 1: Gunakan CONCATENATE() = CONCATENATE ( A1 , CHAR ( 10 ) , A2 ) Metode 2: Gunakan TEXTJOIN() = TEXTJOIN ( CHAR ( 10 ) , TRUE , A1:A2 ) Kedua rumus tersebut akan menggabungkan nilai di sel A1 dan A2 […]<\/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":"\nGoogle Spreadsheet: Menggabungkan sel dengan jeda baris \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan sel dengan jeda baris di Google Sheets, beserta contohnya.\" \/>\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-digabungkan-dengan-baris-baru\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Menggabungkan sel dengan jeda baris \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan sel dengan jeda baris di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T15:20:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lb1.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-digabungkan-dengan-baris-baru\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/\",\"name\":\"Google Spreadsheet: Menggabungkan sel dengan jeda baris \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T15:20:47+00:00\",\"dateModified\":\"2023-07-09T15:20:47+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan sel dengan jeda baris di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: menggabungkan sel dengan jeda baris\"}]},{\"@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":"Google Spreadsheet: Menggabungkan sel dengan jeda baris \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggabungkan sel dengan jeda baris di Google Sheets, beserta contohnya.","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-digabungkan-dengan-baris-baru\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Menggabungkan sel dengan jeda baris \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggabungkan sel dengan jeda baris di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/","og_site_name":"Statorials","article_published_time":"2023-07-09T15:20:47+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lb1.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-digabungkan-dengan-baris-baru\/","url":"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/","name":"Google Spreadsheet: Menggabungkan sel dengan jeda baris \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T15:20:47+00:00","dateModified":"2023-07-09T15:20:47+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan sel dengan jeda baris di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-digabungkan-dengan-baris-baru\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: menggabungkan sel dengan jeda baris"}]},{"@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\/4613"}],"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=4613"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4613\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}