{"id":2038,"date":"2023-10-23T16:38:56","date_gmt":"2023-10-23T16:38:56","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/"},"modified":"2023-12-10T06:00:27","modified_gmt":"2023-12-10T06:00:27","slug":"bir-dizi-hucreyi-birlestirmek","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/","title":{"rendered":"Excel&#39;de bir dizi h\u00fccre nas\u0131l birle\u015ftirilir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2394138912\"><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>De\u011ferleri CONCATENATE ile birle\u015ftirmek en iyi yoldur ancak bu fonksiyonla aral\u0131\u011f\u0131n tamam\u0131na ba\u015fvurmak m\u00fcmk\u00fcn de\u011fildir. Bir aral\u0131ktaki t\u00fcm h\u00fccreleri tek tek se\u00e7meniz gerekir ve aral\u0131\u011f\u0131n tamam\u0131na ba\u015fvurmaya \u00e7al\u0131\u015f\u0131rsan\u0131z, ilk h\u00fccredeki metni d\u00f6nd\u00fcr\u00fcr.<\/p><p> Bu durumda, t\u00fcm h\u00fccre aral\u0131\u011f\u0131n\u0131 tek bir h\u00fccrede birle\u015ftirmek i\u00e7in referans verecek bir y\u00f6nteme ihtiyac\u0131n\u0131z vard\u0131r. Bug\u00fcn bu yaz\u0131mda aral\u0131k metnini tek bir h\u00fccrede birle\u015ftirmenin 5 farkl\u0131 yolunu sizlerle payla\u015fmak istiyorum.<\/p><h2 id=\"tab-con-9\" class=\"wp-block-heading\"> De\u011ferleri birle\u015ftirmek i\u00e7in [CONCATENATE + TRANSPOSE]<\/h2><p> Farkl\u0131 h\u00fccrelerdeki metni tek bir h\u00fccrede birle\u015ftirmenin en iyi yolu <strong><span style=\"color: #000000;\">, birle\u015ftirme i\u015fleviyle birlikte devrikle\u015ftirme i\u015flevini kullanmakt\u0131r<\/span><\/strong> .<\/p><p> Baz\u0131 metinlerin oldu\u011fu, ancak her kelimenin farkl\u0131 bir h\u00fccrede oldu\u011fu ve hepsini tek bir h\u00fccreye koymak istedi\u011finiz a\u015fa\u011f\u0131daki h\u00fccre aral\u0131\u011f\u0131na bak\u0131n. Bu h\u00fccre aral\u0131\u011f\u0131ndaki de\u011ferleri tek bir h\u00fccrede birle\u015ftirme ad\u0131mlar\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p><ol><li> B8&#8217;e ( <a href=\"https:\/\/exceladvisor.org\/tr\/hucreyi-duzenle\/\">F2 kullanarak h\u00fccreyi d\u00fczenleyin<\/a> ), a\u015fa\u011f\u0131daki form\u00fcl\u00fc ekleyin ve Enter tu\u015funa basmay\u0131n.<ul><li> =B\u0130RLE\u015eT\u0130R(D\u00d6N\u00dc\u015e(A1:A5)&amp; \u00bb \u00ab )<\/li><\/ul><\/li><li> \u015eimdi birle\u015ftirme fonksiyonunun i\u00e7 k\u0131sm\u0131n\u0131n tamam\u0131n\u0131 se\u00e7in ve F9 tu\u015funa bas\u0131n. Bunu bir diziye d\u00f6n\u00fc\u015ft\u00fcrecek.<\/li><li> Daha sonra masan\u0131n ba\u015f\u0131ndaki ve sonundaki parantezleri \u00e7\u0131kar\u0131n.<\/li><li> Sonunda Enter tu\u015funa bas\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1.gif\" sizes=\"\" srcset=\"\" alt=\"bir dizi h\u00fccreyi birle\u015ftirilmi\u015f bir transpoze ile birle\u015ftirin\"><\/figure><\/div><p> Bu kadar.<\/p><h3 class=\"wp-block-heading\"> Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h3><p> Bu form\u00fclde, B\u0130RLE\u015eT\u0130RME&#8217;de TRANSPOSE ve bo\u015fluk kulland\u0131n\u0131z. <a href=\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/\" data-wpil=\"url\">Bu referans\u0131 sabit de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrd\u00fc\u011f\u00fcn\u00fczde<\/a> bir dizi d\u00f6nd\u00fcr\u00fcr. Bu tabloda her h\u00fccrenin metni ve aralar\u0131nda bir bo\u015fluk bulunur ve enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda hepsini birle\u015ftirir.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Yaslanm\u0131\u015f Doldurma se\u00e7ene\u011fini kullanarak metni birle\u015ftirin<\/h2><p> <a href=\"https:\/\/exceladvisor.org\/tr\/filigran-ekle\/\">Gerek\u00e7eyi Doldur,<\/a> Excel&#8217;deki kullan\u0131lmayan ancak en g\u00fc\u00e7l\u00fc ara\u00e7lardan biridir. Ve farkl\u0131 h\u00fccrelerdeki metni birle\u015ftirmeniz gerekti\u011finde bunu kullanabilirsiniz. En iyi \u015fey, <strong><span style=\"color: #000000;\">metni birle\u015ftirmek i\u00e7in yaln\u0131zca tek bir t\u0131klamaya ihtiyac\u0131n\u0131z olmas\u0131d\u0131r<\/span><\/strong> . A\u015fa\u011f\u0131daki verilere bak\u0131n ve ad\u0131mlar\u0131 izleyin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-concatener-une-plage-de-cellules-avec-justification-de-remplissage-1.gif\" sizes=\"\" srcset=\"\" alt=\"2 bir dizi h\u00fccreyi dolgu gerek\u00e7esi ile birle\u015ftirir\"><\/figure><\/div><ol><li> \u00d6ncelikle metninizin bulundu\u011fu s\u00fctunun geni\u015fli\u011fini artt\u0131rd\u0131\u011f\u0131n\u0131zdan emin olun.<\/li><li> Bundan sonra t\u00fcm h\u00fccreleri se\u00e7in.<\/li><li> Sonunda Ana Sayfa sekmesine gidin \u279c D\u00fczenle \u279c Doldur \u279c Yasla.<\/li><\/ol><p> Bu, t\u00fcm h\u00fccrelerdeki metni se\u00e7imin ilk h\u00fccresinde birle\u015ftirecektir.<\/p><h2 id=\"tab-con-10\" class=\"wp-block-heading\"> CONCATENATE de\u011ferleri i\u00e7in TEXTJOIN i\u015flevi<\/h2><p> <a href=\"https:\/\/support.office.com\/en-us\/article\/Download-and-install-or-reinstall-Office-365-or-Office-2016-on-a-PC-or-Mac-4414EAAF-0478-48BE-9C42-23ADC4716658?ui=en-US&amp;rs=en-US&amp;ad=US&amp;fromAR=1\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Excel 2016 (Office 365)<\/a> kullan\u0131yorsan\u0131z &#8220;TextJoin&#8221; ad\u0131nda bir fonksiyon bulunmaktad\u0131r. Bu, farkl\u0131 h\u00fccrelerdeki metni tek bir h\u00fccrede kolayca birle\u015ftirmenize olanak tan\u0131r.<\/p><h3 id=\"tab-con-6\" class=\"wp-block-heading\"> S\u00f6zdizimi:<\/h3><p> <span style=\"font-family: Courier New,Courier,monospace;\">TEXTJOIN(s\u0131n\u0131rlay\u0131c\u0131, g\u00f6rmezden_bo\u015f, metin1, [metin2], \u2026)<\/span><\/p><ol><li> s\u0131n\u0131rlay\u0131c\u0131 olarak kullan\u0131lacak bir metin dizesini <strong>s\u0131n\u0131rland\u0131r\u0131n<\/strong> .<\/li><li> bo\u015f h\u00fccreyi yoksaymak i\u00e7in <strong>g\u00f6rmezden_empty<\/strong> true, bunu yapmamak i\u00e7in false.<\/li><li> <strong>text1<\/strong> birle\u015ftirilecek metin.<\/li><li> <strong>[text2]<\/strong> iste\u011fe ba\u011fl\u0131 olarak birle\u015ftirilecek metin.<\/li><\/ol><h3 id=\"tab-con-8\" class=\"wp-block-heading\"> bu nas\u0131l kullan\u0131l\u0131r<\/h3><p> A\u015fa\u011f\u0131daki de\u011fer listesini birle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\" \",TRUE,A1:A5)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-concatener-une-plage-de-cellules-avec-une-jointure-de-texte-min-1.png\" sizes=\"\" srcset=\"\" alt=\"3 minimum metin birle\u015fimiyle bir h\u00fccre aral\u0131\u011f\u0131n\u0131 birle\u015ftirir\"><\/figure><\/div><p> Burada s\u0131n\u0131rlay\u0131c\u0131 olarak bo\u015fluk kulland\u0131n\u0131z, bo\u015f h\u00fccreleri ve t\u00fcm aral\u0131\u011f\u0131 tek bir ba\u011f\u0131ms\u0131z de\u011fi\u015fkende yok saymak i\u00e7in DO\u011eRU&#8217;yu kulland\u0131n\u0131z. Sonunda Enter tu\u015funa bas\u0131n, t\u00fcm metni tek bir h\u00fccrede alacaks\u0131n\u0131z.<\/p><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> Metni Power Query ile birle\u015ftirme<\/h2><p> Power Query harika bir ara\u00e7t\u0131r ve onu seviyorum. Buna g\u00f6z atmay\u0131 unutmay\u0131n ( <strong><a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\">Excel Power Query E\u011fitimi<\/a><\/strong> ). Bunu bir listedeki metni tek bir h\u00fccrede birle\u015ftirmek i\u00e7in de kullanabilirsiniz. Ad\u0131mlar a\u015fa\u011f\u0131dad\u0131r.<\/p><ol><li> H\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7in ve Veri sekmesinde &#8220;Tablodan&#8221; se\u00e7ene\u011fini t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"4-bir h\u00fccre aral\u0131\u011f\u0131n\u0131-tablodan-min-g\u00fc\u00e7 sorgusu ile birle\u015ftirin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-concatener-une-plage-de-cellules-avec-une-requete-de-puissance-a-partir-de-la-table-min-1.png\" sizes=\"\" srcset=\"\" alt=\"4 concatenate a range of cells with power query from table min\"><\/li><li> Verilerinizi Power Query d\u00fczenleyicisinde d\u00fczenlerseniz. <br><img decoding=\"async\" title=\"5-bir h\u00fccre aral\u0131\u011f\u0131n\u0131-g\u00fc\u00e7-sorgu-d\u00fczenleyicisi-min ile birle\u015ftirin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-concatener-une-plage-de-cellules-avec-un-editeur-de-requete-puissant-min-1.png\" sizes=\"\" srcset=\"\" alt=\"5 concatenate a range of cells with power query editor min\"><\/li><li> \u015eimdi buradan s\u00fctunu se\u00e7in ve \u201cD\u00f6n\u00fc\u015ft\u00fcrme Sekmesi\u201dne gidin.<\/li><li> \u201cD\u00f6n\u00fc\u015ft\u00fcr\u201d sekmesinde Tabloya gidin ve \u201cTranspoze\u201dye t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"6-bir h\u00fccre aral\u0131\u011f\u0131n\u0131-g\u00fc\u00e7-sorgu-d\u00f6n\u00fc\u015f-dk ile birle\u015ftirin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-concatener-une-plage-de-cellules-avec-power-query-transpose-min-1.png\" sizes=\"\" srcset=\"\" alt=\"7-concatenate-a-range-of-cells-with-power-query-horizontal-min\"><\/li><li> Bunu yapmak i\u00e7in t\u00fcm s\u00fctunlar\u0131 se\u00e7in (ilk s\u00fctunu se\u00e7in, Shift tu\u015funu bas\u0131l\u0131 tutun, son s\u00fctuna t\u0131klay\u0131n) ve sa\u011f t\u0131klay\u0131p ard\u0131ndan &#8220;Birle\u015ftir&#8221;i se\u00e7in. <br><img decoding=\"async\" title=\"8-bir h\u00fccre aral\u0131\u011f\u0131n\u0131-g\u00fc\u00e7-sorgu-birle\u015ftirme-h\u00fccreleri-min ile birle\u015ftirin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-concatener-une-plage-de-cellules-avec-power-query-fusionner-des-cellules-min-1.png\" sizes=\"\" srcset=\"\" alt=\"8 concatenate a range of cells with power query merge cells min\"><\/li><li> Daha sonra birle\u015ftirme penceresinde ay\u0131r\u0131c\u0131 olarak bo\u015flu\u011fu se\u00e7in ve s\u00fctuna bir ad verin. <br><img decoding=\"async\" title=\"9-bir-h\u00fccre-aral\u0131\u011f\u0131n\u0131-g\u00fc\u00e7-sorgu-yeni-s\u00fctun-ad\u0131-dak ile birle\u015ftirin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-concatener-une-plage-de-cellules-avec-power-query-nouveau-nom-de-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"9 concatenate a range of cells with power query new column name min\"><\/li><li> Sonunda Tamam&#8217;a t\u0131klay\u0131n ve \u201cKapat ve Y\u00fckle\u201d ye t\u0131klay\u0131n.<\/li><\/ol><p> Art\u0131k \u00e7al\u0131\u015fma kitab\u0131n\u0131zda t\u00fcm metnin tek bir h\u00fccrede oldu\u011fu yeni bir \u00e7al\u0131\u015fma sayfan\u0131z var. Power Query kullanman\u0131n en iyi yan\u0131, bu kurulumu tekrar tekrar yapman\u0131za gerek olmamas\u0131d\u0131r.<\/p><p> Eski listeyi yeni bir de\u011ferle g\u00fcncelledi\u011finizde sorgunuzu yenilemeniz gerekir ve bu yeni de\u011feri h\u00fccreye ekleyecektir.<\/p><h2 id=\"tab-con-7\" class=\"wp-block-heading\"> De\u011ferleri birle\u015ftirmek i\u00e7in VBA kodu<\/h2><p> Farkl\u0131 h\u00fccrelerdeki metinleri birle\u015ftirmek i\u00e7in makro kodu kullanmak istiyorsan\u0131z size g\u00f6re bir \u015feyim var. Bu kodla metni an\u0131nda birle\u015ftirebilirsiniz. Tek yapman\u0131z gereken metnin bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7ip bu kodu \u00e7al\u0131\u015ft\u0131rmak.<\/p><pre class=\"wp-block-code\"><code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\"> Sub combineText() Dim rng As Range Dim i As String For Each rng In Selection i = i &amp; rng &amp; \" \" Next rng Range(\"B1\").Value = Trim(i) End Sub<\/code><\/pre><p> Metni birle\u015ftirmek istedi\u011finiz kodda istedi\u011finiz konumu belirtti\u011finizden emin olun.<\/p><h2 class=\"wp-block-heading\"> Sonunda,<\/h2><p> Bir dizi h\u00fccreyi tek bir h\u00fccrede birle\u015ftirmeniz gereken farkl\u0131 durumlar olabilir. \u0130\u015fte bu y\u00fczden bu farkl\u0131 y\u00f6ntemlerimiz var.<\/p><p> T\u00fcm y\u00f6ntemler h\u0131zl\u0131 ve kolayd\u0131r, ihtiya\u00e7lar\u0131n\u0131za g\u00f6re do\u011fru y\u00f6ntemi se\u00e7meniz gerekir. \u015eunu s\u00f6ylemeliyim ki, t\u00fcm y\u00f6ntemleri bir kez deneyin ve bana \u015funu s\u00f6yleyin:<\/p><p> <strong>Hangisi favoriniz ve i\u015finize yarad\u0131?<\/strong><\/p><p> L\u00fctfen g\u00f6r\u00fc\u015flerinizi yorum k\u0131sm\u0131nda benimle payla\u015f\u0131n. Sizden haber almay\u0131 \u00e7ok isterim ve l\u00fctfen bu g\u00f6nderiyi arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim onlar da bunu takdir edeceklerdir.<\/p><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucrede-yeni-satir\/\">Excel&#8217;de bir h\u00fccreye yeni bir sat\u0131r ekleme (sat\u0131r sonu)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bastaki-sifirlar\/\">Excel&#8217;de ba\u015ftaki s\u0131f\u0131rlar\u0131 ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucreleri-virgulle-birlestir\/\">Excel&#8217;de h\u00fccreleri virg\u00fclle birle\u015ftirme (birle\u015ftirme)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sonunu-birlestirme\/\">Excel&#8217;de sat\u0131r sonuyla birle\u015ftirme<\/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-2038","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 dizi h\u00fccre nas\u0131l birle\u015ftirilir?<\/title>\n<meta name=\"description\" content=\"Farkl\u0131 durumlarda kullanabilece\u011finiz, bir dizi h\u00fccreyi tek bir h\u00fccrede birle\u015ftirmenin 5 y\u00f6ntemini burada bulabilirsiniz.\" \/>\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\/bir-dizi-hucreyi-birlestirmek\/\" \/>\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 dizi h\u00fccre nas\u0131l birle\u015ftirilir?\" \/>\n<meta property=\"og:description\" content=\"Farkl\u0131 durumlarda kullanabilece\u011finiz, bir dizi h\u00fccreyi tek bir h\u00fccrede birle\u015ftirmenin 5 y\u00f6ntemini burada bulabilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1.gif\" \/>\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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/\",\"name\":\"Excel&#39;de bir dizi h\u00fccre nas\u0131l birle\u015ftirilir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1.gif\",\"datePublished\":\"2023-10-23T16:38:56+00:00\",\"dateModified\":\"2023-12-10T06:00:27+00:00\",\"description\":\"Farkl\u0131 durumlarda kullanabilece\u011finiz, bir dizi h\u00fccreyi tek bir h\u00fccrede birle\u015ftirmenin 5 y\u00f6ntemini burada bulabilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de bir dizi h\u00fccre nas\u0131l birle\u015ftirilir?\"}]},{\"@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 dizi h\u00fccre nas\u0131l birle\u015ftirilir?","description":"Farkl\u0131 durumlarda kullanabilece\u011finiz, bir dizi h\u00fccreyi tek bir h\u00fccrede birle\u015ftirmenin 5 y\u00f6ntemini burada bulabilirsiniz.","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\/bir-dizi-hucreyi-birlestirmek\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de bir dizi h\u00fccre nas\u0131l birle\u015ftirilir?","og_description":"Farkl\u0131 durumlarda kullanabilece\u011finiz, bir dizi h\u00fccreyi tek bir h\u00fccrede birle\u015ftirmenin 5 y\u00f6ntemini burada bulabilirsiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/","url":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/","name":"Excel&#39;de bir dizi h\u00fccre nas\u0131l birle\u015ftirilir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1.gif","datePublished":"2023-10-23T16:38:56+00:00","dateModified":"2023-12-10T06:00:27+00:00","description":"Farkl\u0131 durumlarda kullanabilece\u011finiz, bir dizi h\u00fccreyi tek bir h\u00fccrede birle\u015ftirmenin 5 y\u00f6ntemini burada bulabilirsiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de bir dizi h\u00fccre nas\u0131l birle\u015ftirilir?"}]},{"@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\/2038","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=2038"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2038\/revisions"}],"predecessor-version":[{"id":2407,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2038\/revisions\/2407"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}