{"id":3715,"date":"2023-07-15T23:40:53","date_gmt":"2023-07-15T23:40:53","guid":{"rendered":"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/"},"modified":"2023-07-15T23:40:53","modified_gmt":"2023-07-15T23:40:53","slug":"kueri-google-sheet-masukkan-kolom-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/","title":{"rendered":"Kueri google spreadsheet: cara memasukkan kolom kosong ke dalam output"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut dalam kueri Google Spreadsheet untuk menyisipkan kolom kosong ke dalam keluaran kueri:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span dir=\"auto\" style=\"color: #ff6600;\">A1:C12<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">SELECT A, ' ', B LABEL ' ' ''<\/span> \"<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri khusus ini akan memilih kolom A dalam rentang <strong>A1:C12<\/strong> , lalu menyisipkan kolom kosong, lalu memilih kolom B dalam rentang <strong>A1:C12<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Klausa <strong>LABEL<\/strong> memberitahu kueri untuk menggunakan header kosong untuk kolom kosong baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Sisipkan kolom kosong dalam kueri Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30329 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vide1-1.jpg\" alt=\"\" width=\"501\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk memilih kolom A dalam rentang <strong>A1:C12<\/strong> , lalu menyisipkan kolom kosong, lalu memilih kolom B dalam rentang <strong>A1:C12<\/strong> .<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span dir=\"auto\" style=\"color: #ff6600;\">A1:C12<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">SELECT A, ' ', B LABEL ' ' ''<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan kueri ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30330\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/blanc2.jpg\" alt=\"Kueri Google Spreadsheet menyisipkan kolom kosong\" width=\"520\" height=\"658\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kueri mengembalikan nilai kolom A dari kumpulan data asli, lalu kolom kosong, lalu nilai kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin menyisipkan beberapa kolom kosong, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span dir=\"auto\" style=\"color: #ff6600;\">A1:C12<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">SELECT A, ' ', ' ', B LABEL ' ' '', ' ' ''<\/span> \" )<\/span>\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan kueri ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30331 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/blanc3.jpg\" alt=\"\" width=\"604\" height=\"626\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kueri ini menyisipkan dua kolom kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa kita harus menggunakan klausa <strong>LABEL<\/strong> untuk menentukan dua label kosong untuk dua kolom kosong baru.<\/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 hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/permintaan-tunggal-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara mengembalikan baris unik saja<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: cara menghapus header dari hasil<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara Mengabaikan Sel Kosong di Kueri<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut dalam kueri Google Spreadsheet untuk menyisipkan kolom kosong ke dalam keluaran kueri: =QUERY( A1:C12 , &#8221; SELECT A, &#8216; &#8216;, B LABEL &#8216; &#8216; &#8221; &#8221; ) Kueri khusus ini akan memilih kolom A dalam rentang A1:C12 , lalu menyisipkan kolom kosong, lalu memilih kolom B dalam rentang A1:C12 . [&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>Kueri Google Spreadsheet: Cara menyisipkan kolom kosong di keluaran - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyisipkan kolom kosong ke dalam output kueri 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\/kueri-google-sheet-masukkan-kolom-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kueri Google Spreadsheet: Cara menyisipkan kolom kosong di keluaran - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyisipkan kolom kosong ke dalam output kueri Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T23:40:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vide1-1.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\/kueri-google-sheet-masukkan-kolom-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/\",\"name\":\"Kueri Google Spreadsheet: Cara menyisipkan kolom kosong di keluaran - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T23:40:53+00:00\",\"dateModified\":\"2023-07-15T23:40:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyisipkan kolom kosong ke dalam output kueri Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara memasukkan kolom kosong ke dalam output\"}]},{\"@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":"Kueri Google Spreadsheet: Cara menyisipkan kolom kosong di keluaran - Statorial","description":"Tutorial ini menjelaskan cara menyisipkan kolom kosong ke dalam output kueri 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\/kueri-google-sheet-masukkan-kolom-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara menyisipkan kolom kosong di keluaran - Statorial","og_description":"Tutorial ini menjelaskan cara menyisipkan kolom kosong ke dalam output kueri Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-15T23:40:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vide1-1.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\/kueri-google-sheet-masukkan-kolom-kosong\/","url":"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/","name":"Kueri Google Spreadsheet: Cara menyisipkan kolom kosong di keluaran - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T23:40:53+00:00","dateModified":"2023-07-15T23:40:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyisipkan kolom kosong ke dalam output kueri Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kueri-google-sheet-masukkan-kolom-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara memasukkan kolom kosong ke dalam output"}]},{"@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\/3715"}],"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=3715"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3715\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}