{"id":1619,"date":"2023-11-15T08:08:27","date_gmt":"2023-11-15T08:08:27","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/"},"modified":"2023-12-10T06:00:40","modified_gmt":"2023-12-10T06:00:40","slug":"pivot-tabloyu-siralama","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/","title":{"rendered":"Excel&#39;de bir pivot tablo nas\u0131l s\u0131ralan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-637690914\"><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>Evet, Excel&#8217;de bir pivot tabloyu s\u0131ralayabilirsiniz. S\u0131ralama, \u00f6zel ihtiya\u00e7lar\u0131n\u0131za ba\u011fl\u0131 olarak farkl\u0131 \u015fekillerde yap\u0131labilir. Pivot tabloyu s\u0131ralamak i\u00e7in genel ad\u0131mlar \u015funlard\u0131r:<\/p><h2 class=\"wp-block-heading\"> <strong>De\u011ferlere g\u00f6re s\u0131rala<\/strong><\/h2><p> \u00c7ok basit bir pivot tablo olu\u015ftural\u0131m. Burada en \u00e7ok satan \u00fcr\u00fcn\u00fc bulmak i\u00e7in Genel Toplam\u0131 k\u00fc\u00e7\u00fckten b\u00fcy\u00fc\u011fe do\u011fru s\u0131ralamak istedik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-59372\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tri-base-sur-les-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"de\u011ferlere g\u00f6re s\u0131ralama\" width=\"526\" height=\"186\"><\/figure><\/div><ol><li> \u00d6ncelikle genel toplam s\u00fctunundaki herhangi bir h\u00fccreyi se\u00e7in ve Ana Sayfa sekmesine gidin. <br><img loading=\"lazy\" decoding=\"async\" title=\"sekme 2-eve git\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-aller-a-longlet-daccueil.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-home-tab\" width=\"858\" height=\"111\"><\/li><li> Daha sonra D\u00fczenleme alt\u0131nda S\u0131rala ve Filtrele&#8217;ye t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-D\u00fczenlerken s\u0131ralay\u0131n ve filtreleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-trier-et-filtrer-sous-edition.png\" sizes=\"auto, \" srcset=\"\" alt=\"sort-and-filter-under-editing\" width=\"835\" height=\"108\"><\/li><li> S\u0131rala ve Filtrele se\u00e7ene\u011fine t\u0131klad\u0131ktan sonra bir a\u00e7\u0131l\u0131r liste g\u00f6r\u00fcnecektir. <br><img loading=\"lazy\" decoding=\"async\" title=\"4 s\u0131ralama ve filtreleme se\u00e7ene\u011fi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-options-de-tri-et-de-filtrage.png\" sizes=\"auto, \" srcset=\"\" alt=\"sort-and-filter-option\" width=\"187\" height=\"233\"><\/li><li> Burada gerekli \u201cEn b\u00fcy\u00fckten en k\u00fc\u00e7\u00fc\u011fe s\u0131rala\u201d se\u00e7ene\u011fini bulacaks\u0131n\u0131z. Verilerinizi s\u0131ralamak i\u00e7in yaln\u0131zca tek bir t\u0131klama. <br><img loading=\"lazy\" decoding=\"async\" title=\"En b\u00fcy\u00fc\u011f\u00fcnden en k\u00fc\u00e7\u00fc\u011f\u00fcne 5 b\u00fcy\u00fc\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-trier-du-plus-grand-au-plus-petit.png\" sizes=\"auto, \" srcset=\"\" alt=\"sort-largest-to-smallest\" width=\"187\" height=\"232\"><\/li><li> Son olarak veriler s\u0131ralan\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-veri s\u0131ral\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-donnees-triees.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorted-data\" width=\"517\" height=\"180\"><\/li><\/ol><p> Benzer \u015fekilde ayn\u0131 ad\u0131mlar\u0131 takip ederek verileri en k\u00fc\u00e7\u00fckten en b\u00fcy\u00fc\u011fe do\u011fru s\u0131ralayabilirsiniz.<\/p><ol><li> Ba\u015flamak i\u00e7in toplam sat\u0131r\u0131ndaki herhangi bir h\u00fccreyi tekrar t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"Toplam sat\u0131rdaki herhangi bir h\u00fccreye 7 t\u0131klama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-cliquez-sur-nimporte-quelle-cellule-dans-la-ligne-totale.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-any-cell-in-total-row\" width=\"513\" height=\"182\"><\/li><li> \u015eimdi Ana Sayfa \u2192 S\u0131rala ve Filtrele&#8217;ye gidin. <br><img loading=\"lazy\" decoding=\"async\" title=\"8 t\u0131klamayla s\u0131ralay\u0131n ve filtreleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Trier-et-filtrer-en-8-clics.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-sort-and-filter\" width=\"882\" height=\"114\"><\/li><li> Oradan B\u00fcy\u00fckten K\u00fc\u00e7\u00fc\u011fe&#8217;yi t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"9 b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe do\u011fru s\u0131ralay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-trier-du-plus-grand-au-plus-petit.png\" sizes=\"auto, \" srcset=\"\" alt=\"sort-largest-to-smallest\" width=\"197\" height=\"245\"><\/li><li> Toplam sat\u0131r en b\u00fcy\u00fckten en k\u00fc\u00e7\u00fc\u011fe do\u011fru s\u0131ralan\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"Toplam 10 sat\u0131r s\u0131raland\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-lignes-au-total-triees.png\" sizes=\"auto, \" srcset=\"\" alt=\"total-row-sorted\" width=\"499\" height=\"170\"><\/li><\/ol><p> Yukar\u0131daki pivot tabloda, genel toplam s\u00fctunlar\u0131 ve sat\u0131rlar\u0131 en b\u00fcy\u00fck de\u011ferden en k\u00fc\u00e7\u00fc\u011f\u00fcne do\u011fru s\u0131ralanm\u0131\u015ft\u0131r.<\/p><h2 class=\"wp-block-heading\"> <strong>Pivot tablonun \u00f6zel s\u0131ralamas\u0131<\/strong><\/h2><p> D\u00fc\u015f\u00fcn\u00fcn, art\u0131k \u00dcr\u00fcn Pastas\u0131n\u0131 \u201cen k\u00fc\u00e7\u00fc\u011f\u00fcnden en b\u00fcy\u00fc\u011f\u00fcne\u201d veya tam tersi \u015fekilde s\u0131ralaman\u0131z gerekiyor. Bunu \u00f6zel bir s\u0131ralama se\u00e7ene\u011fini kullanarak yapabilirsiniz.<\/p><ol><li> Genel toplamlar\u0131 s\u0131ralamad\u0131\u011f\u0131m\u0131z i\u00e7in Pasta sat\u0131r\u0131nda genel toplam hari\u00e7 herhangi bir de\u011fere t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"11 \u00e7e\u015fit \u00f6zel d\u00f6ner\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-tri-personnalise-dun-tableau-croise-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"custom-sort-a-pivot-table\" width=\"516\" height=\"180\"><\/li><li> \u015eimdi Ana Sayfa \u2192 S\u0131rala ve D\u00fczenle&#8217;ye t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"12-s\u0131rala ve d\u00fczenle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-trier-et-editer.png\" sizes=\"auto, \" srcset=\"\" alt=\"sort-and-editing\" width=\"896\" height=\"114\"><\/li><li> A\u00e7\u0131l\u0131r oka t\u0131klad\u0131ktan sonra \u00d6zel S\u0131ralama&#8217;ya t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"13 t\u0131klamayla ki\u015fiselle\u015ftirilmi\u015f s\u0131ralama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Tri-personnalise-en-13-clics.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-custom-sort\" width=\"194\" height=\"236\"><\/li><li> Burada \u201cDe\u011fere G\u00f6re S\u0131rala\u201d penceresini a\u00e7acaks\u0131n\u0131z. <br><img loading=\"lazy\" decoding=\"async\" title=\"De\u011fere g\u00f6re 14 s\u0131ralama se\u00e7ene\u011fi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-option-de-tri-par-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"sort-by-value-option\" width=\"360\" height=\"263\"><\/li><li> \u015eimdi S\u0131ralama Se\u00e7ene\u011fi alt\u0131nda En B\u00fcy\u00fckten En K\u00fc\u00e7\u00fc\u011fe&#8217;yi se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"En b\u00fcy\u00fc\u011f\u00fcnden en k\u00fc\u00e7\u00fc\u011f\u00fcne 15 se\u00e7im\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-selectionner-du-plus-grand-au-plus-petit.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-largest-to-smallest\" width=\"360\" height=\"263\"><\/li><li> Ayn\u0131 \u015fekilde s\u0131ralama y\u00f6n\u00fcn\u00fc de se\u00e7in. Burada oldu\u011fu gibi soldan sa\u011fa s\u0131ralama yapmak istedi\u011fimiz i\u00e7in Soldan Sa\u011fa&#8217;y\u0131 se\u00e7ece\u011fiz. <br><img loading=\"lazy\" decoding=\"async\" title=\"16-s\u0131ralama y\u00f6n\u00fcn\u00fc se\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-selectionner-le-sens-du-tri.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-sort-direction\" width=\"360\" height=\"263\"><\/li><li> Buraday\u0131z. Art\u0131k hangi ay\u0131n en y\u00fcksek ve en d\u00fc\u015f\u00fck sat\u0131\u015flara sahip oldu\u011funu kolayca \u00f6\u011frenebilirsiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"Veriler 17 aya g\u00f6re s\u0131ralanm\u0131\u015ft\u0131r\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Donnees-triees-sur-17-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"month-wise-sorted-data\" width=\"518\" height=\"180\"><\/li><\/ol><p> Peki ya pivotunuzda se\u00e7ilen model d\u0131\u015f\u0131nda k\u00fc\u00e7\u00fck bir de\u011fi\u015fiklik yapman\u0131z gerekirse?<\/p><p> \u00d6rne\u011fin, Ocak ay\u0131ndan Aral\u0131k ay\u0131na kadar olan sat\u0131\u015f verileriniz var. Diyelim ki i\u00e7inde bulundu\u011fumuz ay\u0131, \u00f6rne\u011fin a\u011fustos ay\u0131n\u0131 zirveye \u00e7\u0131karacaks\u0131n\u0131z? Bu tan\u0131mlanm\u0131\u015f hi\u00e7bir modele uymuyor.<\/p><p> Endi\u015felenmeyin, bu m\u00fcmk\u00fcn. Bu gibi durumlarda pivot tabloyu manuel olarak s\u0131ralayabilirsiniz. \u0130\u015fte basit bir \u00f6rnek. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-59409\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-trier-le-tableau-croise-dynamique-manuellement.png\" sizes=\"auto, \" srcset=\"\" alt=\"manuel olarak s\u0131ralama-pivot-dizisi\" width=\"481\" height=\"301\"><\/figure><\/div><p> \u015eimdi yukar\u0131daki tabloda Ocak ay\u0131ndan Aral\u0131k ay\u0131na kadar s\u00fctunlar halinde d\u00fczenlenmi\u015f veriler ve alfabetik olarak s\u0131ralanm\u0131\u015f \u00fclkeler var. \u201cA\u011fustos\u201du ilk s\u00fctuna ve \u201cHindistan\u201d\u0131 en \u00fcst s\u0131raya getirmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin.<\/p><ol><li> \u00d6ncelikle ta\u015f\u0131mak istedi\u011finiz s\u00fctun ba\u015fl\u0131\u011f\u0131n\u0131 se\u00e7in. Burada oldu\u011fu gibi a\u011fustos ay\u0131n\u0131 da ta\u015f\u0131mak istiyoruz. Yani Aug h\u00fccresini se\u00e7ece\u011fiz. <br><img loading=\"lazy\" decoding=\"async\" title=\"19-select-s\u00fctun-ba\u015fl\u0131\u011f\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-selectionner-len-tete-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-header-of-column\" width=\"675\" height=\"280\"><\/li><li> Unutmay\u0131n, yaln\u0131zca ba\u015fl\u0131k h\u00fccresini se\u00e7memiz gerekiyor.<\/li><li> \u015eimdi, imlecinizi se\u00e7ilen h\u00fccrenin kenar\u0131na getirdi\u011finizde, imleci hareket ettiren bir nesne g\u00f6r\u00fcnecektir. <br><img loading=\"lazy\" decoding=\"async\" title=\"20 se\u00e7meli ba\u015fl\u0131k h\u00fccresi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-selectionnez-la-cellule-den-tete.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-header-cell\" width=\"450\" height=\"279\"><\/li><li> Bundan sonra fareye t\u0131klay\u0131n ve s\u00fctunu ta\u015f\u0131mak istedi\u011finiz konuma s\u00fcr\u00fckleyin. Burada onu ilk s\u00fctuna s\u00fcr\u00fckleyece\u011fiz. <br><img loading=\"lazy\" decoding=\"async\" title=\"21 kayd\u0131rmal\u0131 s\u00fctundan konuma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-faites-glisser-la-colonne-vers-la-position.png\" sizes=\"auto, \" srcset=\"\" alt=\"drag-the-column-to-the-position\" width=\"684\" height=\"284\"><\/li><li> Ayn\u0131 \u015fekilde ad\u0131mlar\u0131 \u00fclkeyle de tekrarlay\u0131n.<\/li><li> &#8220;Hindistan&#8221;\u0131 se\u00e7in ve hareket imlecini almak i\u00e7in imleci kenarl\u0131k \u00fczerinde hareket ettirin ve onu ilk konuma s\u00fcr\u00fckleyin. <br><img loading=\"lazy\" decoding=\"async\" title=\"22-kayd\u0131rmal\u0131 ilk konuma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-glisser-vers-la-premiere-position.png\" sizes=\"auto, \" srcset=\"\" alt=\"drag-to-first-position\" width=\"484\" height=\"311\"><\/li><\/ol><h2 class=\"wp-block-heading\"> <strong>Alfabetik olarak s\u0131rala<\/strong><\/h2><p> \u015eimdi izleyicilerimize kolayl\u0131k sa\u011flamak i\u00e7in \u00fclkeleri alfabetik olarak s\u0131ralayal\u0131m. Bu iki farkl\u0131 \u015fekilde yap\u0131labilir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-59418\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/23-trier-par-ordre-alphabetique.png\" sizes=\"auto, \" srcset=\"\" alt=\"alfabetik olarak s\u0131rala\" width=\"296\" height=\"227\"><\/figure><\/div><ol><li> Ba\u015flamak i\u00e7in bu \u00f6rnekte \u00fcst h\u00fccredeki \u201cHindistan\u201d\u0131 t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"\u00dcst h\u00fccreye 24 t\u0131klama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/24-cliquez-sur-la-cellule-du-haut.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-the-top-cell\" width=\"281\" height=\"213\"><\/li><li> \u015eimdi Ana Sayfa sekmesine t\u0131klay\u0131n ve S\u0131rala ve Filtrele d\u00fc\u011fmesine gidin. <br><img loading=\"lazy\" decoding=\"async\" title=\"25 ad\u0131mda s\u0131ralay\u0131n ve filtreleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/25-aller-pour-trier-et-filtrer.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-sort-and-filter\" width=\"135\" height=\"227\"><\/li><li> Burada \u201cA&#8217;dan Z&#8217;ye S\u0131rala\u201d se\u00e7ene\u011fine t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"A'dan Z'ye 26 b\u00fcy\u00fc\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/26-trier-de-a-a-z.png\" sizes=\"auto, \" srcset=\"\" alt=\"sort-A-to-Z\" width=\"134\" height=\"154\"><\/li><li> Veriler s\u0131ralan\u0131r. Art\u0131k \u00fclkelerin A&#8217;dan Z&#8217;ye alfabetik olarak s\u0131raland\u0131\u011f\u0131n\u0131 g\u00f6r\u00fcyorsunuz. <br><img loading=\"lazy\" decoding=\"async\" title=\"27 veri s\u0131ral\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/27-donnees-triees.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorted-data\" width=\"290\" height=\"222\"><\/li><\/ol><p> Alfabetik olarak s\u0131ralaman\u0131n ba\u015fka bir y\u00f6ntemini kullanmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 da kullanabilirsiniz.<\/p><ol><li> Pivot tabloda ba\u015fl\u0131k h\u00fccresini, yani \u201c\u00dclke\u201dyi se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"28-ba\u015fl\u0131k h\u00fccresi se\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/28-selectionner-la-cellule-den-tete.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-header-cell\" width=\"292\" height=\"222\"><\/li><li> \u015eimdi \u201c\u00dclke\u201dnin yan\u0131ndaki k\u00fc\u00e7\u00fck a\u00e7\u0131l\u0131r oka t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"A\u00e7\u0131l\u0131r listede 29 t\u0131klama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/29-cliquez-sur-le-menu-deroulant.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-on-drop-down\" width=\"228\" height=\"341\"><\/li><li> \u015eimdi ilk se\u00e7ene\u011fe t\u0131klay\u0131n, yani \u201cA&#8217;dan Z&#8217;ye S\u0131rala\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"A'dan Z'ye 30 b\u00fcy\u00fc\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/30-trier-de-a-a-z.png\" sizes=\"auto, \" srcset=\"\" alt=\"sort-A-to-Z\" width=\"226\" height=\"337\"><\/li><li> Buraday\u0131z. \u00dclkeler A&#8217;dan Z&#8217;ye alfabetik olarak listelenmi\u015ftir. <br><img loading=\"lazy\" decoding=\"async\" title=\"A'dan Z'ye s\u0131ralanm\u0131\u015f 31 veri\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/31-donnees-triees-de-a-a-z.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorted-data-A-to-Z\" width=\"281\" height=\"216\"><\/li><\/ol>","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-1619","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>Excel&#039;de bir pivot tablo nas\u0131l s\u0131ralan\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu \u00f6\u011freticide, s\u0131ralaman\u0131za yard\u0131mc\u0131 olabilecek farkl\u0131 y\u00f6ntemleri kullanarak bir pivot tabloyu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenebilirsiniz.\" \/>\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\/pivot-tabloyu-siralama\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de bir pivot tablo nas\u0131l s\u0131ralan\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu \u00f6\u011freticide, s\u0131ralaman\u0131za yard\u0131mc\u0131 olabilecek farkl\u0131 y\u00f6ntemleri kullanarak bir pivot tabloyu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenebilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tri-base-sur-les-valeurs.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\/pivot-tabloyu-siralama\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/\",\"name\":\"Excel&#39;de bir pivot tablo nas\u0131l s\u0131ralan\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tri-base-sur-les-valeurs.png\",\"datePublished\":\"2023-11-15T08:08:27+00:00\",\"dateModified\":\"2023-12-10T06:00:40+00:00\",\"description\":\"Bu \u00f6\u011freticide, s\u0131ralaman\u0131za yard\u0131mc\u0131 olabilecek farkl\u0131 y\u00f6ntemleri kullanarak bir pivot tabloyu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenebilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tri-base-sur-les-valeurs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tri-base-sur-les-valeurs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de bir pivot tablo nas\u0131l s\u0131ralan\u0131r?\"}]},{\"@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":"Excel&#39;de bir pivot tablo nas\u0131l s\u0131ralan\u0131r?","description":"Bu \u00f6\u011freticide, s\u0131ralaman\u0131za yard\u0131mc\u0131 olabilecek farkl\u0131 y\u00f6ntemleri kullanarak bir pivot tabloyu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenebilirsiniz.","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\/pivot-tabloyu-siralama\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de bir pivot tablo nas\u0131l s\u0131ralan\u0131r?","og_description":"Bu \u00f6\u011freticide, s\u0131ralaman\u0131za yard\u0131mc\u0131 olabilecek farkl\u0131 y\u00f6ntemleri kullanarak bir pivot tabloyu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenebilirsiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:40+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tri-base-sur-les-valeurs.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\/pivot-tabloyu-siralama\/","url":"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/","name":"Excel&#39;de bir pivot tablo nas\u0131l s\u0131ralan\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tri-base-sur-les-valeurs.png","datePublished":"2023-11-15T08:08:27+00:00","dateModified":"2023-12-10T06:00:40+00:00","description":"Bu \u00f6\u011freticide, s\u0131ralaman\u0131za yard\u0131mc\u0131 olabilecek farkl\u0131 y\u00f6ntemleri kullanarak bir pivot tabloyu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenebilirsiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tri-base-sur-les-valeurs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tri-base-sur-les-valeurs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tabloyu-siralama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de bir pivot tablo nas\u0131l s\u0131ralan\u0131r?"}]},{"@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\/1619","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=1619"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1619\/revisions"}],"predecessor-version":[{"id":2425,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1619\/revisions\/2425"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}