{"id":4511,"date":"2023-07-10T12:51:06","date_gmt":"2023-07-10T12:51:06","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/"},"modified":"2023-07-10T12:51:06","modified_gmt":"2023-07-10T12:51:06","slug":"excel-ic-birlestirme","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/","title":{"rendered":"Excel&#39;de i\u0307\u00e7 birle\u015ftirme nas\u0131l yap\u0131l\u0131r (\u00f6rnekle)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>\u0130\u00e7 birle\u015ftirme,<\/strong> sonu\u00e7ta ortaya \u00e7\u0131kan tablodaki sat\u0131rlar\u0131n yaln\u0131zca her iki tablo i\u00e7in ortak bir s\u00fctunda e\u015fle\u015fen de\u011ferlere sahip oldu\u011fu iki tabloyu birle\u015ftirmenize olanak tan\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, iki tabloda i\u00e7 birle\u015ftirme ger\u00e7ekle\u015ftirmek i\u00e7in Excel&#8217;deki <b>Power Query<\/b> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ad\u0131m 1: Her tablo i\u00e7in de\u011ferleri girin<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;de iki tablo i\u00e7in a\u015fa\u011f\u0131daki de\u011ferleri girerek ba\u015flayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35239 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij1.png\" alt=\"\" width=\"491\" height=\"407\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Her tablodan yaln\u0131zca <strong>Tak\u0131m<\/strong> s\u00fctununda e\u015fle\u015fen de\u011ferlere sahip sat\u0131rlar\u0131 tutaca\u011f\u0131m\u0131z bir i\u00e7 birle\u015ftirme ger\u00e7ekle\u015ftirece\u011fiz.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ad\u0131m 2: Her Aral\u0131\u011f\u0131 Tabloya D\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Daha sonra her de\u011fer aral\u0131\u011f\u0131n\u0131 bir diziye d\u00f6n\u00fc\u015ft\u00fcrmemiz gerekiyor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6ncelikle <strong>A1:B8<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulay\u0131n, ard\u0131ndan \u00fcst \u015feritteki Ekle sekmesine ve ard\u0131ndan <strong>Tablo<\/strong> simgesine t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35240 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij2.png\" alt=\"\" width=\"488\" height=\"474\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A\u00e7\u0131lan yeni pencerede <strong>Tamam<\/strong> butonuna t\u0131klay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>D1:E6<\/strong> h\u00fccre aral\u0131\u011f\u0131 i\u00e7in bu ad\u0131mlar\u0131 tekrarlay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Her iki veri aral\u0131\u011f\u0131 da art\u0131k tablo halinde g\u00f6r\u00fcnecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35241 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij3.png\" alt=\"\" width=\"501\" height=\"407\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>3. Ad\u0131m: \u0130\u00e7 birle\u015ftirme ger\u00e7ekle\u015ftirmek i\u00e7in Power Query&#8217;yi kullan\u0131n<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Daha sonra, ilk tablodaki herhangi bir h\u00fccreye sa\u011f t\u0131klay\u0131n ve a\u00e7\u0131l\u0131r men\u00fcden <b>Tablo\/Aral\u0131k Verilerini Al&#8217;a<\/b> t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35242 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij4.png\" alt=\"\" width=\"403\" height=\"531\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Tablo Power Query d\u00fczenleyicisine y\u00fcklenecektir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra, sol \u00fcst k\u00f6\u015fedeki <strong>Kapat ve Y\u00fckle<\/strong> simgesine t\u0131klay\u0131n ve ard\u0131ndan a\u00e7\u0131l\u0131r men\u00fcden <strong>Kapat ve \u015euraya Y\u00fckle se\u00e7ene\u011fine<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35243 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij5.png\" alt=\"\" width=\"578\" height=\"417\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">G\u00f6r\u00fcnt\u00fclenen yeni pencerede <strong>Yaln\u0131zca ba\u011flant\u0131 olu\u015ftur&#8217;u<\/strong> se\u00e7in ve ard\u0131ndan <strong>Tamam&#8217;a<\/strong> t\u0131klay\u0131n:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35244 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij6.png\" alt=\"\" width=\"313\" height=\"325\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Ard\u0131ndan, ikinci tablodaki herhangi bir h\u00fccreye sa\u011f t\u0131klay\u0131n ve a\u00e7\u0131l\u0131r men\u00fcden <b>Tablo\/Aral\u0131k Verilerini Al&#8217;a<\/b> t\u0131klay\u0131n:<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u0130kinci tablo Power Query d\u00fczenleyicisine y\u00fcklenecektir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ard\u0131ndan, Power Query D\u00fczenleyicisi&#8217;nin \u00fcst \u015feridindeki <strong>Birle\u015ftir<\/strong> grubundaki <strong>Sorgular\u0131 Birle\u015ftir<\/strong> simgesine t\u0131klay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u00e7\u0131lan yeni pencerede, <strong>Tablo1&#8217;i<\/strong> ilk kutuya, <strong>Tablo2&#8217;yi<\/strong> ikinci kutuya yerle\u015ftirin. Daha sonra her tablodaki <strong>ekip<\/strong> s\u00fctununa t\u0131klay\u0131n. Ard\u0131ndan <strong>Birle\u015ftirme T\u00fcr\u00fc<\/strong> a\u00e7\u0131l\u0131r men\u00fcs\u00fcnde <strong>\u0130\u00e7&#8217;e<\/strong> t\u0131klay\u0131n ve <strong>Tamam&#8217;a<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-35245\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij7.png\" alt=\"Excel'de i\u00e7 birle\u015ftirme\" width=\"649\" height=\"580\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Tamam&#8217;a<\/strong> t\u0131klad\u0131\u011f\u0131n\u0131zda i\u00e7 birle\u015ftirme ger\u00e7ekle\u015ftirilecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35246 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij8.png\" alt=\"\" width=\"578\" height=\"370\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Ard\u0131ndan, <strong>Tablo2<\/strong> etiketli s\u00fctundaki sol ve sa\u011f ok simgelerine t\u0131klay\u0131n ve ard\u0131ndan <strong>Tamam&#8217;a<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35247 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij9.png\" alt=\"\" width=\"453\" height=\"355\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u0130kinci tablonun <strong>ribaund<\/strong> s\u00fctunu g\u00f6r\u00fcnecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35248 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij10.png\" alt=\"\" width=\"535\" height=\"187\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Son olarak <strong>Kapat ve \u015euraya Y\u00fckle<\/strong> simgesine tekrar t\u0131klay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">G\u00f6r\u00fcnt\u00fclenen yeni pencerede <strong>Tablo<\/strong> ve <strong>Yeni \u00c7al\u0131\u015fma Sayfas\u0131&#8217;n\u0131<\/strong> ve ard\u0131ndan <strong>Tamam&#8217;\u0131<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35249 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij11.png\" alt=\"\" width=\"358\" height=\"367\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u0130\u00e7 birle\u015fimden kaynaklanan son tablo art\u0131k yeni bir \u00e7al\u0131\u015fma sayfas\u0131nda g\u00f6r\u00fcnt\u00fclenecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35250 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij12.png\" alt=\"\" width=\"430\" height=\"378\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Yaln\u0131zca her iki tabloda da g\u00f6r\u00fcnen tak\u0131m adlar\u0131n\u0131 i\u00e7eren sat\u0131rlar\u0131n final tablosunda yer ald\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/tr\/excelde-sol-katilim\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de sola birle\u015ftirme nas\u0131l yap\u0131l\u0131r<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excelde-bulanik-eslestirme\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de bulan\u0131k e\u015fle\u015ftirme nas\u0131l ger\u00e7ekle\u015ftirilir?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/baska-bir-calisma-kitabindan-excel-vlookup\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131ndan D\u00dc\u015eEYARA nas\u0131l kullan\u0131l\u0131r?<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0130\u00e7 birle\u015ftirme, sonu\u00e7ta ortaya \u00e7\u0131kan tablodaki sat\u0131rlar\u0131n yaln\u0131zca her iki tablo i\u00e7in ortak bir s\u00fctunda e\u015fle\u015fen de\u011ferlere sahip oldu\u011fu iki tabloyu birle\u015ftirmenize olanak tan\u0131r. A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, iki tabloda i\u00e7 birle\u015ftirme ger\u00e7ekle\u015ftirmek i\u00e7in Excel&#8217;deki Power Query i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir. Ad\u0131m 1: Her tablo i\u00e7in de\u011ferleri girin Excel&#8217;de iki tablo i\u00e7in a\u015fa\u011f\u0131daki de\u011ferleri girerek [&hellip;]<\/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":[],"class_list":["post-4511","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de \u0130\u00e7 Birle\u015ftirme Nas\u0131l Yap\u0131l\u0131r (\u00d6rnekle) - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#039;de i\u00e7 birle\u015ftirmenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/tr\/excel-ic-birlestirme\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de \u0130\u00e7 Birle\u015ftirme Nas\u0131l Yap\u0131l\u0131r (\u00d6rnekle) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#039;de i\u00e7 birle\u015ftirmenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T12:51:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/\",\"name\":\"Excel&#39;de \u0130\u00e7 Birle\u015ftirme Nas\u0131l Yap\u0131l\u0131r (\u00d6rnekle) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-10T12:51:06+00:00\",\"dateModified\":\"2023-07-10T12:51:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;de i\u00e7 birle\u015ftirmenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de i\u0307\u00e7 birle\u015ftirme nas\u0131l yap\u0131l\u0131r (\u00f6rnekle)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de \u0130\u00e7 Birle\u015ftirme Nas\u0131l Yap\u0131l\u0131r (\u00d6rnekle) - Statorials","description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;de i\u00e7 birle\u015ftirmenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","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\/tr\/excel-ic-birlestirme\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de \u0130\u00e7 Birle\u015ftirme Nas\u0131l Yap\u0131l\u0131r (\u00d6rnekle) - Statorials","og_description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;de i\u00e7 birle\u015ftirmenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/","og_site_name":"Statorials","article_published_time":"2023-07-10T12:51:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/","url":"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/","name":"Excel&#39;de \u0130\u00e7 Birle\u015ftirme Nas\u0131l Yap\u0131l\u0131r (\u00d6rnekle) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-10T12:51:06+00:00","dateModified":"2023-07-10T12:51:06+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;de i\u00e7 birle\u015ftirmenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-ic-birlestirme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de i\u0307\u00e7 birle\u015ftirme nas\u0131l yap\u0131l\u0131r (\u00f6rnekle)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4511"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4511\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}