{"id":2863,"date":"2023-07-20T08:48:49","date_gmt":"2023-07-20T08:48:49","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/"},"modified":"2023-07-20T08:48:49","modified_gmt":"2023-07-20T08:48:49","slug":"tabel-pivot-lembar-google-tab-silang-beberapa-lembar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/","title":{"rendered":"Google spreadsheet: cara membuat pivottable dari beberapa lembar"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat tabel pivot dari beberapa lembar di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki lembar kerja dengan dua lembar berlabel <strong>minggu1<\/strong> dan <strong>minggu2<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Minggu 1:<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25056 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-multiple1.jpg\" alt=\"\" width=\"543\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Minggu 2:<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25057 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-multiple2.jpg\" alt=\"\" width=\"545\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat tabel pivot menggunakan data dari kedua lembar.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Gabungkan data ke dalam satu lembar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sebelum kita bisa membuat tabel pivot menggunakan kedua sheet, kita perlu menggabungkan semua data ke dalam satu sheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus <strong>QUERY<\/strong> berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY({ <span style=\"color: #ff6600;\">week1!A1:C11<\/span> ; <span style=\"color: #800080;\">week2!A2:C11<\/span> })\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menggunakan rumus ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25058 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-multiple3.jpg\" alt=\"\" width=\"478\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa data dari lembar <strong>minggu1<\/strong> dan <strong>minggu2<\/strong> kini digabungkan menjadi satu lembar.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Buat PivotTable<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk membuat PivotTable, kita akan menyorot nilai dalam rentang <strong>A1:C21<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu <strong>PivotTable<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat membuat tabel pivot berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25059 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-multiple4.jpg\" alt=\"\" width=\"678\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot terakhir mencakup data dari lembar <strong>minggu1<\/strong> dan <strong>minggu2<\/strong> .<\/span><\/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\/tabel-pivot-keluaran-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara mengurutkan tabel pivot<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bidang-google-sheet-menghitung\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara menambahkan bidang terhitung ke tabel pivot<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-tabel-pivot-google-sheet-dari-total\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Tampilkan persentase total dalam tabel pivot<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh langkah demi langkah berikut menunjukkan cara membuat tabel pivot dari beberapa lembar di Google Spreadsheet. Langkah 1: Masukkan datanya Katakanlah kita memiliki lembar kerja dengan dua lembar berlabel minggu1 dan minggu2 : Minggu 1: Minggu 2: Katakanlah kita ingin membuat tabel pivot menggunakan data dari kedua lembar. Langkah 2: Gabungkan data ke dalam satu [&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>Google Spreadsheet: Cara Membuat PivotTable dari Beberapa Sheet - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa sheet di Google Sheets, dengan sebuah 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\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara Membuat PivotTable dari Beberapa Sheet - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa sheet di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T08:48:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-multiple1.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\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/\",\"name\":\"Google Spreadsheet: Cara Membuat PivotTable dari Beberapa Sheet - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T08:48:49+00:00\",\"dateModified\":\"2023-07-20T08:48:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa sheet di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara membuat pivottable dari beberapa lembar\"}]},{\"@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: Cara Membuat PivotTable dari Beberapa Sheet - Statorial","description":"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa sheet di Google Sheets, dengan sebuah 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\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara Membuat PivotTable dari Beberapa Sheet - Statorial","og_description":"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa sheet di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/","og_site_name":"Statorials","article_published_time":"2023-07-20T08:48:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-multiple1.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\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/","name":"Google Spreadsheet: Cara Membuat PivotTable dari Beberapa Sheet - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T08:48:49+00:00","dateModified":"2023-07-20T08:48:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa sheet di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-lembar-google-tab-silang-beberapa-lembar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara membuat pivottable dari beberapa lembar"}]},{"@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\/2863"}],"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=2863"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2863\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}