{"id":3292,"date":"2023-07-18T06:26:55","date_gmt":"2023-07-18T06:26:55","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/"},"modified":"2023-07-18T06:26:55","modified_gmt":"2023-07-18T06:26:55","slug":"tabel-pivot-excel-beberapa-lembar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/","title":{"rendered":"Excel: cara membuat pivottable dari beberapa lembar"},"content":{"rendered":"

<\/p>\n

\n

Contoh langkah demi langkah berikut ini memperlihatkan cara membuat tabel pivot dari beberapa lembar di Excel<\/span><\/p>\n

Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n

Katakanlah kita memiliki lembar kerja dengan dua lembar berlabel minggu1<\/strong> dan minggu2<\/strong> :<\/span><\/p>\n

Minggu 1:<\/strong><\/span> <\/p>\n

\"\"<\/p>\n

Minggu 2:<\/strong><\/span> <\/p>\n

\"\"<\/p>\n

Katakanlah kita ingin membuat tabel pivot menggunakan data dari kedua lembar.<\/span><\/p>\n

Langkah 2: Gabungkan data ke dalam satu lembar<\/strong><\/span><\/h2>\n

Sebelum kita bisa membuat tabel pivot menggunakan kedua sheet, kita perlu menggabungkan semua data ke dalam satu sheet.<\/span><\/p>\n

Kita dapat menggunakan rumus FILTER<\/b> berikut untuk melakukan ini:<\/span><\/p>\n

 =FILTER(week2!A2:C11, week2!A2:A11<>\"\")\n<\/strong><\/pre>\n
 Kita bisa mengetikkan rumus ini di sel A12<\/strong> pada lembar minggu 1<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Rumus ini memberitahu Excel untuk mengembalikan semua baris pada lembar minggu ke-2<\/strong> yang nilai dalam rentang A2:A11<\/strong> pada lembar tersebut tidak kosong.<\/span><\/p>\n
 Semua baris dari lembar minggu1<\/strong> dan minggu2<\/strong> kini dikelompokkan menjadi satu lembar.<\/span><\/p>\n
 Langkah 3: Buat PivotTable<\/strong><\/span><\/h2>\n
 Untuk membuat PivotTable, klik tab Sisipkan<\/strong> , lalu klik PivotTable<\/strong> di grup Tabel<\/strong> .<\/span><\/p>\n
 Pada jendela baru yang muncul, masukkan informasi berikut lalu klik OK<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Di panel Bidang PivotTable<\/strong> yang muncul di sisi kanan layar, seret Toko<\/strong> ke area Baris, seret Produk<\/strong> ke area Kolom, dan seret Penjualan<\/strong> ke area Nilai:<\/span> <\/p>\n
\"\"<\/p>\n
 Tabel pivot berikut akan dibuat secara otomatis:<\/span> <\/p>\n
\"\"<\/p>\n
 Tabel pivot terakhir mencakup data dari lembar minggu1<\/strong> dan minggu2<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n
 Tabel pivot Excel: menghitung jumlah dan jumlah bidang yang sama<\/a>
 Excel: Cara Membuat PivotTable Berdasarkan Data yang Difilter<\/a>
 Excel: Cara Menerapkan Beberapa Filter ke PivotTable Sekaligus<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Contoh langkah demi langkah berikut ini memperlihatkan cara membuat tabel pivot dari beberapa lembar di Excel 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 […]<\/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":"\nExcel: Cara Membuat PivotTable dari Beberapa Lembar - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa lembar di Excel, termasuk 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\/tabel-pivot-excel-beberapa-lembar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Membuat PivotTable dari Beberapa Lembar - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa lembar di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T06:26:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques1.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-excel-beberapa-lembar\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/\",\"name\":\"Excel: Cara Membuat PivotTable dari Beberapa Lembar - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T06:26:55+00:00\",\"dateModified\":\"2023-07-18T06:26:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa lembar di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: 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":"Excel: Cara Membuat PivotTable dari Beberapa Lembar - Statorial","description":"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa lembar di Excel, termasuk 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\/tabel-pivot-excel-beberapa-lembar\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Membuat PivotTable dari Beberapa Lembar - Statorial","og_description":"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa lembar di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/","og_site_name":"Statorials","article_published_time":"2023-07-18T06:26:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques1.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-excel-beberapa-lembar\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/","name":"Excel: Cara Membuat PivotTable dari Beberapa Lembar - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T06:26:55+00:00","dateModified":"2023-07-18T06:26:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel pivot dari beberapa lembar di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: 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\/3292"}],"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=3292"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3292\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}