{"id":1881,"date":"2023-10-30T09:32:27","date_gmt":"2023-10-30T09:32:27","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/"},"modified":"2023-12-10T05:59:07","modified_gmt":"2023-12-10T05:59:07","slug":"dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/","title":{"rendered":"Birden fazla sayfa i\u00e7eren bir pivot tablo nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3472091777\"><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>Pivot tablo, verileri \u00f6zetlemenin en iyi yollar\u0131ndan biridir.<\/p><p> Binlerce sat\u0131rl\u0131k veriden saniyeler i\u00e7inde \u00f6zet rapor olu\u015fturabilirsiniz. Ancak ger\u00e7ek d\u00fcnyadaki verilerle \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda her \u015fey m\u00fckemmel de\u011fildir.<\/p><p> Bug\u00fcn sizlerle hepimizin kar\u015f\u0131la\u015ft\u0131\u011f\u0131 ortak bir sorunu payla\u015fmak istiyorum.<\/p><p> Ba\u015flamadan \u00f6nce sorusu i\u00e7in Raman Girdhar&#8217;a te\u015fekk\u00fcr etmek istiyorum. Kendisi beni uzun s\u00fcredir takip ediyor.<\/p><p> Bazen verilerimizi farkl\u0131 \u00e7al\u0131\u015fma kitaplar\u0131nda al\u0131r\u0131z veya yakalar\u0131z ve bu durumda bir pivot tablo olu\u015fturmak, bu birden fazla \u00e7al\u0131\u015fma kitab\u0131n\u0131 tek bir \u00e7al\u0131\u015fma kitab\u0131nda birle\u015ftirmek i\u00e7in ekstra \u00e7aba gerektirir.<\/p><p> Ancak bundan sonra bir pivot tablo olu\u015fturabiliriz.<\/p><p> Bu makalede size birden fazla \u00e7al\u0131\u015fma kitab\u0131ndaki verileri kullanarak bir pivot tablo olu\u015fturman\u0131n \u00fc\u00e7 ad\u0131ml\u0131 s\u00fcrecini g\u00f6stermek istiyorum.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Birden \u00c7ok \u00c7al\u0131\u015fma Kitab\u0131ndaki Verileri Kullanarak PivotTable Olu\u015fturma Ad\u0131mlar\u0131<\/h2><p class=\"qt-tip\"> <strong>\u00d6nemli:<\/strong> Bunun i\u00e7in g\u00fc\u00e7 sorgusunu kullanmam\u0131z gerekiyor, bu nedenle Excel s\u00fcr\u00fcm\u00fcn\u00fczde g\u00fc\u00e7 sorgusunun oldu\u011fundan emin olun. Excel 2016 i\u00e7in Veri sekmesinde bulunur ve di\u011fer s\u00fcr\u00fcmler i\u00e7in (2010 ve 2013) eklentiyi <a href=\"https:\/\/www.microsoft.com\/en-in\/download\/details.aspx?id=39379\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">y\u00fcklemeniz<\/a> gerekir.<\/p><p> Burada farkl\u0131 alanlara y\u00f6nelik sat\u0131\u015f verilerini i\u00e7eren d\u00f6rt farkl\u0131 \u00e7al\u0131\u015fma kitab\u0131m var. <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-vente.zip\" rel=\"nofollow\">Takip etmek i\u00e7in bu dosyalar\u0131 buradan indirebilirsiniz<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-tableau-croise-dynamique-utilisant-plusieurs-fichiers-dossier-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Ve t\u00fcm bu dosyalar\u0131n tek bir klas\u00f6rde oldu\u011fundan emin olun.<\/p><h3 id=\"tab-con-2\" class=\"wp-block-heading\"> Ad\u0131m 1 \u2013 Power Query Kullanarak Dosyalar\u0131 Birle\u015ftirin<\/h3><p> \u00d6ncelikle PowerQuery ile t\u00fcm dosyalar\u0131 tek dosyada birle\u015ftirmemiz gerekiyor. <\/p><ul id=\"block-981dee7c-6093-413b-ad99-8b6e2839c397\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"981dee7c-6093-413b-ad99-8b6e2839c397\" data-type=\"core\/list\" data-title=\"List\"><li> Veri sekmesine gidin -&gt; D\u00f6n\u00fc\u015f\u00fcm\u00fc Al -&gt; Yeni Sorgu -&gt; Dosyadan -&gt; Klas\u00f6rden. <br><img decoding=\"async\" title=\"1-pivot-tablo-kullanarak-birden fazla dosya-g\u00fc\u00e7-sorgu-a\u00e7\u0131k-klas\u00f6r-min\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-croise-dynamique-utilisant-plusieurs-fichiers-power-query-ouvrir-le-dossier-min.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> \u015eimdi klas\u00f6r se\u00e7im penceresinden \u201cG\u00f6zat\u201da t\u0131klay\u0131n ve t\u00fcm dosyalar\u0131n bulundu\u011fu klas\u00f6r\u00fc se\u00e7in. <br><img decoding=\"async\" title=\"2-pivot tablo-birden fazla dosya kullanan-g\u00fc\u00e7-sorgu-se\u00e7im-klas\u00f6r-min\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-tableau-croise-dynamique-utilisant-plusieurs-fichiers-power-query-select-dossier-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><li> Oradan \u201cDosyalar\u0131 Birle\u015ftir\u201d penceresini g\u00f6receksiniz. <br><img decoding=\"async\" title=\"3-pivot tablo-birden fazla-dosya-g\u00fc\u00e7-sorgu-t\u0131klama-birle\u015ftirme-d\u00fczenleme-dak kullanarak\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-tableau-croise-dynamique-utilisant-plusieurs-fichiers-requete-de-puissance-cliquez-sur-combiner-modifier-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Ve bu pencereden t\u00fcm \u00e7al\u0131\u015fma kitaplar\u0131ndaki verilerinizin bulundu\u011fu \u00e7al\u0131\u015fma sayfas\u0131n\u0131 se\u00e7in. (\u0130pucu: T\u00fcm \u00e7al\u0131\u015fma kitaplar\u0131nda ayn\u0131 \u00e7al\u0131\u015fma sayfas\u0131 ad\u0131na sahip oldu\u011funuzdan emin olun). <br><img decoding=\"async\" title=\"4-d\u00f6nd\u00fcr\u00fclebilir-kullanarak-birden fazla-dosya-se\u00e7in-\u00e7al\u0131\u015fma sayfas\u0131n\u0131-d\u00fczenleyiciye-y\u00fcklemek-dakika\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-tableau-croise-dynamique-utilisant-plusieurs-fichiers-selectionnez-la-feuille-de-calcul-a-charger-dans-lediteur-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Tamam&#8217;a t\u0131klad\u0131\u011f\u0131n\u0131zda \u00e7al\u0131\u015fma kitaplar\u0131ndaki t\u00fcm veriler Power Query D\u00fczenleyicisi&#8217;nde d\u00fczenlenecektir.<\/li><\/ul><h3 id=\"tab-con-3\" class=\"wp-block-heading\"> Ad\u0131m 2 \u2013 Pivot tablo i\u00e7in verileri haz\u0131rlay\u0131n<\/h3><p> \u015eimdi verilerimizi pivot tabloya haz\u0131rlamak i\u00e7in k\u00fc\u00e7\u00fck de\u011fi\u015fiklikler yapmam\u0131z gerekiyor. <\/p><ul id=\"block-83f2d8d7-e333-4eec-901a-bdb4a2315313\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"83f2d8d7-e333-4eec-901a-bdb4a2315313\" data-type=\"core\/list\" data-title=\"List\"><li> Verilere bakarsan\u0131z, burada kaynak dosya ad\u0131n\u0131n yer ald\u0131\u011f\u0131 ek bir s\u00fctun g\u00f6r\u00fcyoruz. <br><img decoding=\"async\" title=\"5-pivot tablo-g\u00fc\u00e7-sorgu-d\u00fczenleyici-daki-\u00e7oklu-veri-dosyalar\u0131n\u0131 kullanma-dak\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-tableau-croise-dynamique-utilisant-plusieurs-fichiers-de-donnees-dans-lediteur-de-requetes-Power-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Bu s\u00fctuna sa\u011f t\u0131klay\u0131n ve S\u00fctunu b\u00f6l -&gt; S\u0131n\u0131rlay\u0131c\u0131ya g\u00f6re se\u00e7ene\u011fini se\u00e7in. <br><img decoding=\"async\" title=\"6-pivot-tablo-kullanarak-birden fazla-dosya-ay\u0131r\u0131c\u0131ya-t\u0131klayarak-s\u00fctunu-b\u00f6lme-min\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-tableau-croise-dynamique-utilisant-plusieurs-fichiers-cliquez-sur-le-delimiteur-pour-diviser-la-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> S\u0131n\u0131rlay\u0131c\u0131 penceresinde \u00f6zel se\u00e7ene\u011fini se\u00e7in, s\u0131n\u0131rlay\u0131c\u0131 olarak \u201c\u2013\u201d ekleyin ve \u201cEn soldaki s\u0131n\u0131rlay\u0131c\u0131\u201dy\u0131 se\u00e7in. <br><img decoding=\"async\" title=\"7-pivot tablo-\u00e7oklu-dosya-yakalama-s\u0131n\u0131rlay\u0131c\u0131-s\u00fctunu-b\u00f6lme-dk kullanarak\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-tableau-croise-dynamique-utilisant-plusieurs-fichiers-entrez-un-delimiteur-pour-diviser-la-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><li> Bundan sonra ikinci s\u00fctunu silin. <br><img decoding=\"async\" title=\"8-pivot tablo-birden fazla-dosya-sil-ikinci-s\u00fctun-min kullanarak\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-tableau-croise-dynamique-utilisant-plusieurs-fichiers-supprimer-la-deuxieme-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> \u015eimdi ilk s\u00fctunu yeniden adland\u0131r\u0131n. <br><img decoding=\"async\" title=\"9-pivot tablo-\u00e7oklu-dosya-kullanarak-ilk-s\u00fctun-min'i yeniden adland\u0131r\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-tableau-croise-dynamique-utilisant-plusieurs-fichiers-renommer-la-premiere-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Bir \u015fey daha, ilk s\u00fctuna tekrar sa\u011f t\u0131klay\u0131n ve D\u00f6n\u00fc\u015ft\u00fcr -&gt; Her Kelimeyi B\u00fcy\u00fck Harf Yap&#8217;a gidin. <br><img decoding=\"async\" title=\"10-pivot-tablo-kullanarak-birden fazla dosya-de\u011fi\u015fim-b\u00fcy\u00fck-k\u00fc\u00e7\u00fck-ilk-s\u00fctun-dak\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-tableau-croise-dynamique-utilisant-plusieurs-fichiers-changer-la-casse-de-la-premiere-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Ve art\u0131k verileriniz haz\u0131r. Bu y\u00fczden kapat&#8217;a t\u0131klay\u0131n ve y\u00fckleyin. <br><img decoding=\"async\" title=\"11-\u00e7oklu-dosya-kullanarak-d\u00f6nd\u00fcr\u00fclebilir-t\u0131klama-kapatma-ve-y\u00fckleme-min\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-tableau-croise-dynamique-utilisant-plusieurs-fichiers-cliquez-sur-fermer-et-chargez-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><\/ul><h3 id=\"tab-con-4\" class=\"wp-block-heading\"> Ad\u0131m 3 \u2013 PivotTable&#8217;\u0131 yerle\u015ftirin<\/h3><p> Bu noktada \u00e7al\u0131\u015fma kitab\u0131m\u0131zda d\u00f6rt dosyan\u0131n birle\u015ftirilmi\u015f verilerinin yer ald\u0131\u011f\u0131 yeni bir \u00e7al\u0131\u015fma sayfam\u0131z var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-tableau-croise-dynamique-utilisant-plusieurs-fichiers-nouvelle-feuille-de-calcul-avec-donnees-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> \u015eimdi ondan bir pivot tablo olu\u015fturman\u0131n zaman\u0131 geldi. <\/p><ul id=\"block-63ef554f-b09b-4547-a68b-8466388358b9\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"63ef554f-b09b-4547-a68b-8466388358b9\" data-type=\"core\/list\" data-title=\"List\"><li> Tabloyu se\u00e7in ve Ekle Sekmesi&#8217;ne gidin ve PivotTable d\u00fc\u011fmesini t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"13-pivot-pano-kullanarak-birden fazla dosya-pivot-pano-d\u00fc\u011fmesine t\u0131klay\u0131n-dakika\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-tableau-croise-dynamique-utilisant-plusieurs-fichiers-cliquez-sur-le-bouton-du-tableau-croise-dynamique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Burada bir pivot tablo ekleme penceresi g\u00f6receksiniz. <br><img decoding=\"async\" title=\"14-pivot-tablo-kullanarak-birden fazla-dosya-se\u00e7me-tablo-dak\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-tableau-croise-dynamique-utilisant-plusieurs-fichiers-selectionner-le-tableau-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> PivotTable Ekle penceresinde Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131zda \u00e7al\u0131\u015fma kitab\u0131n\u0131zda yeni bir pivot tablo elde edeceksiniz. <br><img decoding=\"async\" title=\"15-pivot-tablo-kullanarak-birden fazla dosya-son-pivot-tablo-dak\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-tableau-croise-dynamique-utilisant-plusieurs-fichiers-tableau-croise-dynamique-final-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><\/ul><p> Tebrikler! Farkl\u0131 dosyalardan ba\u015far\u0131yla yeni bir pivot tablo olu\u015fturdunuz.<\/p><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> PivotTable&#8217;\u0131 Yenile<\/h2><p> Eminim kaynak dosyalar\u0131 g\u00fcncelledikten sonra pivot tablonuzu nas\u0131l yenileyece\u011finizi d\u00fc\u015f\u00fcn\u00fcyorsunuzdur.<\/p><p> Basit. Pivot tablonuzu yenilemek i\u00e7in, kaynak dosyadaki verilerin PowerQuery ile olu\u015fturdu\u011funuz kaynak tabloda g\u00fcncellenebilmesi i\u00e7in sorguyu g\u00fcncellemeniz gerekir. Bundan sonra pivot tablonuzu g\u00fcncelleyebilirsiniz.<\/p><p> Ancak en kolay ve en iyi yol, veri sekmesindeki yenile d\u00fc\u011fmesini kullanmakt\u0131r. Her ikisine de at\u0131fta bulunacakt\u0131r (pivot tablo + sorgu). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-tableau-croise-dynamique-utilisant-plusieurs-fichiers-bouton-dactualisation-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 id=\"tab-con-6\" class=\"wp-block-heading\"> \u00d6nemli noktalar<\/h2><p> Burada pivot tablo i\u00e7in power query kullan\u0131rken hat\u0131rlaman\u0131z gereken baz\u0131 noktalar\u0131 s\u0131ralad\u0131m.<\/p><ul><li> Dosyalar tek bir klas\u00f6rde olmal\u0131d\u0131r.<\/li><li> Veriler t\u00fcm dosyalarda ayn\u0131 formatta olmal\u0131d\u0131r. Aksi takdirde birle\u015ftirip kullan\u0131labilir hale getirmeniz gerekir.<\/li><li> \u00c7al\u0131\u015fma sayfas\u0131 adlar\u0131 t\u00fcm dosyalarda ayn\u0131 olmal\u0131d\u0131r.<\/li><li> Dosyada hata olmad\u0131\u011f\u0131ndan emin olun. Veya \u201cHata dosyalar\u0131n\u0131 yoksay\u201d se\u00e7ene\u011fini kullanabilirsiniz.<\/li><li> Hi\u00e7bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 yeniden adland\u0131rmay\u0131n.<\/li><\/ul><h2 class=\"wp-block-heading\"> Daha fazlas\u0131n\u0131 okumal\u0131s\u0131n\u0131z<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-1\/\" data-wpil=\"url\">VBA ile PivotTable Nas\u0131l Olu\u015fturulur<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/birden-fazla-calisma-sayfasindan-pivotlama\/\" data-wpil=\"url\">Birden \u00c7ok \u00c7al\u0131\u015fma Sayfas\u0131ndan PivotTable Nas\u0131l Olu\u015fturulur<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\">30 PivotTable \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\">Pivot tabloya \u00f6zel alan ve \u00f6\u011fe nas\u0131l eklenir?<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/her-seyi-yenile\/\">T\u00fcm pivot tablolar\u0131 ayn\u0131 anda nas\u0131l yenileyebilirim?<\/a><\/li><\/ul>","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-1881","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>Birden \u00e7ok sayfa i\u00e7eren bir pivot tablo olu\u015fturma<\/title>\n<meta name=\"description\" content=\"Bug\u00fcn sizlerle hepimizin kar\u015f\u0131la\u015ft\u0131\u011f\u0131 ortak bir sorunun \u00e7\u00f6z\u00fcm\u00fcn\u00fc payla\u015fmak istiyorum. Bir pivot tablo olu\u015fturmak i\u00e7in birden fazla dosyay\u0131 birle\u015ftirin. 3 ad\u0131ml\u0131 bir \u00e7\u00f6z\u00fcm.\" \/>\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\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Birden \u00e7ok sayfa i\u00e7eren bir pivot tablo olu\u015fturma\" \/>\n<meta property=\"og:description\" content=\"Bug\u00fcn sizlerle hepimizin kar\u015f\u0131la\u015ft\u0131\u011f\u0131 ortak bir sorunun \u00e7\u00f6z\u00fcm\u00fcn\u00fc payla\u015fmak istiyorum. Bir pivot tablo olu\u015fturmak i\u00e7in birden fazla dosyay\u0131 birle\u015ftirin. 3 ad\u0131ml\u0131 bir \u00e7\u00f6z\u00fcm.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-tableau-croise-dynamique-utilisant-plusieurs-fichiers-dossier-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/\",\"name\":\"Birden \u00e7ok sayfa i\u00e7eren bir pivot tablo olu\u015fturma\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-tableau-croise-dynamique-utilisant-plusieurs-fichiers-dossier-1.png\",\"datePublished\":\"2023-10-30T09:32:27+00:00\",\"dateModified\":\"2023-12-10T05:59:07+00:00\",\"description\":\"Bug\u00fcn sizlerle hepimizin kar\u015f\u0131la\u015ft\u0131\u011f\u0131 ortak bir sorunun \u00e7\u00f6z\u00fcm\u00fcn\u00fc payla\u015fmak istiyorum. Bir pivot tablo olu\u015fturmak i\u00e7in birden fazla dosyay\u0131 birle\u015ftirin. 3 ad\u0131ml\u0131 bir \u00e7\u00f6z\u00fcm.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-tableau-croise-dynamique-utilisant-plusieurs-fichiers-dossier-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-tableau-croise-dynamique-utilisant-plusieurs-fichiers-dossier-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Birden fazla sayfa i\u00e7eren bir pivot tablo nas\u0131l olu\u015fturulur?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Birden \u00e7ok sayfa i\u00e7eren bir pivot tablo olu\u015fturma","description":"Bug\u00fcn sizlerle hepimizin kar\u015f\u0131la\u015ft\u0131\u011f\u0131 ortak bir sorunun \u00e7\u00f6z\u00fcm\u00fcn\u00fc payla\u015fmak istiyorum. Bir pivot tablo olu\u015fturmak i\u00e7in birden fazla dosyay\u0131 birle\u015ftirin. 3 ad\u0131ml\u0131 bir \u00e7\u00f6z\u00fcm.","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\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/","og_locale":"tr_TR","og_type":"article","og_title":"Birden \u00e7ok sayfa i\u00e7eren bir pivot tablo olu\u015fturma","og_description":"Bug\u00fcn sizlerle hepimizin kar\u015f\u0131la\u015ft\u0131\u011f\u0131 ortak bir sorunun \u00e7\u00f6z\u00fcm\u00fcn\u00fc payla\u015fmak istiyorum. Bir pivot tablo olu\u015fturmak i\u00e7in birden fazla dosyay\u0131 birle\u015ftirin. 3 ad\u0131ml\u0131 bir \u00e7\u00f6z\u00fcm.","og_url":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-tableau-croise-dynamique-utilisant-plusieurs-fichiers-dossier-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/","url":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/","name":"Birden \u00e7ok sayfa i\u00e7eren bir pivot tablo olu\u015fturma","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-tableau-croise-dynamique-utilisant-plusieurs-fichiers-dossier-1.png","datePublished":"2023-10-30T09:32:27+00:00","dateModified":"2023-12-10T05:59:07+00:00","description":"Bug\u00fcn sizlerle hepimizin kar\u015f\u0131la\u015ft\u0131\u011f\u0131 ortak bir sorunun \u00e7\u00f6z\u00fcm\u00fcn\u00fc payla\u015fmak istiyorum. Bir pivot tablo olu\u015fturmak i\u00e7in birden fazla dosyay\u0131 birle\u015ftirin. 3 ad\u0131ml\u0131 bir \u00e7\u00f6z\u00fcm.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-tableau-croise-dynamique-utilisant-plusieurs-fichiers-dossier-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-tableau-croise-dynamique-utilisant-plusieurs-fichiers-dossier-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/dinamik-tablo-birden-fazla-dosyaya-capraz-referans-veriyor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Birden fazla sayfa i\u00e7eren bir pivot tablo nas\u0131l olu\u015fturulur?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1881","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1881"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1881\/revisions"}],"predecessor-version":[{"id":2298,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1881\/revisions\/2298"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}