{"id":1791,"date":"2023-11-04T18:36:02","date_gmt":"2023-11-04T18:36:02","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/"},"modified":"2023-12-06T06:19:46","modified_gmt":"2023-12-06T06:19:46","slug":"data-yang-tidak-diputar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/","title":{"rendered":"Cara membatalkan pivot data di excel menggunakan power query"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-396392495\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Data dalam format crosstab dapat dijadikan laporan karena mudah dipahami. Namun masalahnya muncul ketika Anda perlu menggunakannya lebih sering.<\/p><p> Dalam situasi ini, Anda perlu melakukan upaya dan menghabiskan waktu Anda yang berharga agar dapat digunakan kembali. Pada contoh di bawah, Anda dapat melihat data crosstab. Biar bisa dipakai berulang-ulang, cara terbaiknya adalah dengan UNPIN-nya ya, seperti yang satu ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Dan untuk menghindari perputaran data, cara terbaiknya adalah dengan menggunakan POWER QUERY. Jadi, hari ini di artikel ini, saya ingin berbagi dengan Anda langkah-langkah sederhana untuk mengubah data tab silang menjadi tabel menggunakan opsi unpivot dari POWER QUERY.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah untuk Membatalkan Pivot Data di Excel dengan Power Query<\/h2><p> Menggunakan <strong><a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/permintaan-kekuatan\/\">Power Query<\/a><\/strong> untuk membatalkan pivot tabel data adalah hal yang menyenangkan. Anda akan terkejut betapa mudahnya. Namun sebelum menggunakannya Anda perlu menginstal add-in Power Query jika Anda menggunakan Excel 2013 atau 2010 dan di Excel 2016 sudah ada sebagai \u201cGet &amp; Transform\u201d. Pastikan untuk <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/non-pivoter-les-donnees-brutes.xlsx\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">mengunduh file contoh ini<\/a> untuk mengikutinya.<\/p><ul><li> Pertama, pilih data tab silang Anda dan navigasikan ke tab \u201cData\u201d. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-donnees-non-pivotees-avec-requete-de-puissance-selectionner-la-table-de-donnees-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Di tab data, navigasikan ke Dapatkan &amp; Transformasi \u2192 Dari Tabel. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-donnees-non-pivotees-avec-une-requete-de-puissance-cliquez-sur-le-tableau-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Ketika Anda mengkliknya, itu akan mengubah data tab silang Anda menjadi tabel Excel (jika belum).<\/li><li> Dan, itu akan langsung memuat data ke dalam editor kueri yang canggih. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-donnees-non-pivotees-avec-des-donnees-de-requete-de-puissance-dans-lediteur-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Dari sini kita perlu memilih semua kolom yang ingin kita batalkan pivotnya.<\/li><li> Untuk melakukan ini, pilih kolom Jan dan tahan Shift dan pilih kolom Des.<\/li><li> Setelah itu, klik kanan padanya dan pilih \u201cUnpivot Columns\u201d. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-donnees-non-pivotees-avec-power-query-click-colonnes-non-pivotees-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Sekarang 12 kolom tersebut tidak diputar menjadi dua kolom. Satu untuk bulannya dan satu lagi untuk jumlahnya. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-donnees-non-pivotees-avec-requete-de-puissance-effectuee-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Hal terakhir yang perlu Anda lakukan adalah mengganti nama kolom.<\/li><li> Untuk melakukan ini, klik kanan pada kolom dan ganti namanya (untuk keduanya). <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-donnees-non-pivotees-avec-power-query-renommer-la-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Pada akhirnya, klik <strong>&#8220;Tutup dan muat&#8221;<\/strong> . <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-donnees-non-pivotees-avec-fermeture-de-requete-de-puissance-et-charge-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Sekarang data tab silang Anda diubah menjadi data biasa dan Anda dapat menggunakannya untuk membuat tabel pivot dan semua hal lainnya untuk analisis lebih lanjut dan pelaporan penjualan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-donnees-non-pivotees-avec-power-query-nouvelles-donnees-dans-la-feuille-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Kesimpulan<\/h2><p> Seperti saya katakan, menggunakan PowerQuery itu menyenangkan. Hal ini membuat pekerjaan pivotless Anda jauh lebih mudah sehingga Anda tidak perlu membuang waktu dan tenaga.<\/p><p> Jika tidak, jika Anda memilih metode manual, Anda tidak tahu berapa kali Anda harus memotong dan menempelkan data Anda. Meskipun Anda menggunakan VBA, Anda memerlukan waktu untuk menulis kode.<\/p><p> Dan PowerQuery cukup pintar untuk memahami struktur data Anda.<\/p><p> Saya harap metode ini bermanfaat bagi Anda.<\/p><p> <em>Sekarang beritahu aku satu hal. Pernahkah Anda mencoba mengacaukan jenis data apa pun? Metode apa yang Anda gunakan? Dan, bagaimana menurut Anda membandingkan metode Anda dengan power query? Bagikan pemikiran Anda dengan saya di bagian komentar, saya ingin mendengar pendapat Anda.<\/em><\/p><p> Dan jangan lupa untuk membagikan tip ini kepada teman-teman Anda.<\/p><div class=\"gb-container gb-container-9e2850fe gb-container-mt\"> <a class=\"gb-button gb-button-71636faa gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/permintaan-kekuatan\/\">Power Query di Excel (Tutorial)<\/a><h2 class=\"gb-headline gb-headline-c566b2ed gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-b15ed1bf gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6e9de105\"><div class=\"gb-container gb-container-6e9de105\"><ul><li> Gabungkan [Gabungkan] Beberapa FILE Excel menjadi SATU BUKU CATATAN<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarianv-2\/\">Lakukan VLOOKUP di Power Query di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rantai\/\">Power Query: menggabungkan nilai (teks dan angka)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/\">Power Query: Perbedaan tanggal<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1791","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara membatalkan pivot data menggunakan Power Query<\/title>\n<meta name=\"description\" content=\"Power Query adalah cara terbaik untuk membatalkan pivot data di Excel. Hanya perlu beberapa klik untuk mengonversi...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara membatalkan pivot data menggunakan Power Query\" \/>\n<meta property=\"og:description\" content=\"Power Query adalah cara terbaik untuk membatalkan pivot data di Excel. Hanya perlu beberapa klik untuk mengonversi...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/\",\"name\":\"Cara membatalkan pivot data menggunakan Power Query\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\",\"datePublished\":\"2023-11-04T18:36:02+00:00\",\"dateModified\":\"2023-12-06T06:19:46+00:00\",\"description\":\"Power Query adalah cara terbaik untuk membatalkan pivot data di Excel. Hanya perlu beberapa klik untuk mengonversi...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membatalkan pivot data di excel menggunakan power query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara membatalkan pivot data menggunakan Power Query","description":"Power Query adalah cara terbaik untuk membatalkan pivot data di Excel. Hanya perlu beberapa klik untuk mengonversi...","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:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/","og_locale":"id_ID","og_type":"article","og_title":"Cara membatalkan pivot data menggunakan Power Query","og_description":"Power Query adalah cara terbaik untuk membatalkan pivot data di Excel. Hanya perlu beberapa klik untuk mengonversi...","og_url":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/","url":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/","name":"Cara membatalkan pivot data menggunakan Power Query","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png","datePublished":"2023-11-04T18:36:02+00:00","dateModified":"2023-12-06T06:19:46+00:00","description":"Power Query adalah cara terbaik untuk membatalkan pivot data di Excel. Hanya perlu beberapa klik untuk mengonversi...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membatalkan pivot data di excel menggunakan power query"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1791"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1791\/revisions"}],"predecessor-version":[{"id":2877,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1791\/revisions\/2877"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}