{"id":78,"date":"2025-07-27T20:45:08","date_gmt":"2025-07-27T18:45:08","guid":{"rendered":"https:\/\/baza.kajodata.com\/?p=78"},"modified":"2025-07-27T20:58:31","modified_gmt":"2025-07-27T18:58:31","slug":"groupby-i-pivotby-w-excelu","status":"publish","type":"post","link":"https:\/\/baza.kajodata.com\/?p=78","title":{"rendered":"GROUPBY i PIVOTBY w Excelu"},"content":{"rendered":"\n<p>Niedawno Microsoft doda\u0142 funkcje, kt\u00f3re w zasadzie zast\u0119puj\u0105 tabele przestawne: GROUPBY i PIVOTBY.<\/p>\n\n\n\n<p>Na dobr\u0105 spraw\u0119 cz\u0119sto mog\u0105 one zast\u0105pi\u0107 tabel\u0119 przestawn\u0105. <\/p>\n\n\n\n<p>Poni\u017cej przyk\u0142ad u\u017cycia obu (a i tak, bez wykorzystania wszystkich opcjonalnych argument\u00f3w):<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"936\" height=\"269\" src=\"https:\/\/baza.kajodata.com\/wp-content\/uploads\/2025\/07\/image-10.png\" alt=\"\" class=\"wp-image-79\" srcset=\"https:\/\/baza.kajodata.com\/wp-content\/uploads\/2025\/07\/image-10.png 936w, https:\/\/baza.kajodata.com\/wp-content\/uploads\/2025\/07\/image-10-300x86.png 300w, https:\/\/baza.kajodata.com\/wp-content\/uploads\/2025\/07\/image-10-768x221.png 768w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Niedawno Microsoft doda\u0142 funkcje, kt\u00f3re w zasadzie zast\u0119puj\u0105 tabele przestawne: GROUPBY i PIVOTBY. Na dobr\u0105 spraw\u0119 cz\u0119sto mog\u0105 one zast\u0105pi\u0107 tabel\u0119 przestawn\u0105. Poni\u017cej przyk\u0142ad u\u017cycia obu (a i tak, bez wykorzystania wszystkich opcjonalnych argument\u00f3w):<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[7,16,12],"class_list":["post-78","post","type-post","status-publish","format-standard","hentry","category-excel","tag-excel","tag-pl","tag-tekst"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts\/78","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78"}],"version-history":[{"count":1,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions"}],"predecessor-version":[{"id":80,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions\/80"}],"wp:attachment":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}