{"id":295,"date":"2013-09-12T16:54:16","date_gmt":"2013-09-12T14:54:16","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=295"},"modified":"2022-01-31T17:34:14","modified_gmt":"2022-01-31T16:34:14","slug":"meg-lehet-forditani-a-tablazatot","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/","title":{"rendered":"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot?"},"content":{"rendered":"<p>M\u00e1r 2 \u00f3r\u00e1t dolgoztam egy t\u00e1bl\u00e1zattal, amikor kider\u00fclt, hogy meg kellene ford\u00edtani az eg\u00e9szet, \u00fagy, hogy ami eddig az els\u0151 oszlopban volt, az ezent\u00fal az els\u0151 sorban legyen, \u00e9s persze minden adat mozogjon vele.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft wp-image-296 size-full\" style=\"border: 1px solid grey;\" title=\"T\u00e1bl\u00e1zat megford\u00edt\u00e1sa\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas.jpg\" alt=\"T\u00e1bl\u00e1zat megford\u00edt\u00e1sa a transzpon\u00e1l\u00e1s seg\u00edts\u00e9g\u00e9vel\" width=\"380\" height=\"194\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas.jpg 380w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas-300x153.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas-240x122.jpg 240w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/a><\/p>\n<p><strong>V\u00e1lasz<\/strong>: L\u00e9tezik funkci\u00f3, amivel az oszlopokat \u00e1talak\u00edthatod sorokk\u00e1, \u00e9s a sorokat oszlopokk\u00e1 &#8211; ez pedig a Transzpon\u00e1l\u00e1s.<!--more--><\/p>\n<p>Ak\u00e1r egy teljes t\u00e1bl\u00e1zatot is \u201emegford\u00edthatsz\u201d.<\/p>\n<h3>Ismerd meg a transzpon\u00e1l\u00e1s funkci\u00f3t!<\/h3>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas.png\"><img decoding=\"async\" class=\"size-full wp-image-1753 alignright\" style=\"border: 1px solid grey;\" title=\"Transzpon\u00e1l\u00e1s\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas.png\" alt=\"A transzpon\u00e1l\u00e1s ikon kicsiben mutatja, hogy a sorb\u00f3l oszlop lesz \u00e9s ford\u00edtva.\" width=\"177\" height=\"205\" \/><\/a>M\u00e1sold ki az adatokat, majd<strong> 2010-es \u00e9s k\u00e9s\u0151bbi Excel verzi\u00f3 eset\u00e9n beilleszt\u00e9s (Ctrl V) ut\u00e1n a Beilleszt\u00e9s be\u00e1ll\u00edt\u00e1sai<\/strong> panelen v\u00e1laszd a Transzpon\u00e1l\u00e1s ikont (a m\u00e1sodik sor v\u00e9g\u00e9n).<\/p>\n<p>Fontos, hogy <strong>csak \u00faj helyre illesztheted<\/strong> az adatokat, \u00fagy, hogy azok az eredetieket semmik\u00e9ppen se fedj\u00e9k.<\/p>\n<h3>Transzpon\u00e1l\u00e1s visszavon\u00e1sa<\/h3>\n<p>Mag\u00e1t a transzpon\u00e1l\u00e1st nem lehet visszavonni &#8211; csak a beilleszt\u00e9st.<\/p>\n<p>Az &#8222;eredeti&#8221; \u00e1llapothoz v\u00e1lassz\u00a0a Beilleszt\u00e9s be\u00e1ll\u00edt\u00e1sai panelen\u00a0egy m\u00e1sik lehet\u0151s\u00e9get.<\/p>\n<h3>Transzpon\u00e1l\u00e1s 2007-es vagy kor\u00e1bbi verzi\u00f3kban<\/h3>\n<p><strong>2007-es \u00e9s kor\u00e1bbi verzi\u00f3kn\u00e1l<\/strong> a Beilleszt\u00e9s helyett a jobbklikk <strong>Ir\u00e1ny\u00edtott beilleszt\u00e9s<\/strong> parancsot kell v\u00e1lasztani.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas-iranyitott-beilleszt\u00e9s.png\"><img decoding=\"async\" class=\"alignleft wp-image-1755\" style=\"border: 1px solid grey;\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas-iranyitott-beilleszt\u00e9s-300x206.png\" alt=\"Az ablak alj\u00e1n tal\u00e1lod a Transzpon\u00e1l\u00e1st\" width=\"360\" height=\"248\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas-iranyitott-beilleszt\u00e9s-300x206.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas-iranyitott-beilleszt\u00e9s-240x165.png 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/09\/transzponalas-iranyitott-beilleszt\u00e9s.png 488w\" sizes=\"(max-width: 360px) 100vw, 360px\" \/><\/a>Itt a felugr\u00f3 ablak alj\u00e1n tudod bepip\u00e1lni a Transzpon\u00e1l\u00e1st (\u00e9s c\u00e9lszer\u0171 egyben az \u00c9rt\u00e9kek opci\u00f3t is megadni).<\/p>\n<h3><strong>M\u00e9g egy tipp<\/strong><\/h3>\n<p>Az eredeti form\u00e1z\u00e1s (f\u0151leg a szeg\u00e9ly) enn\u00e9l a beilleszt\u00e9sn\u00e9l k\u00f6nnyen sz\u00e9tesik.<\/p>\n<p style=\"text-align: left;\">Ez\u00e9rt c\u00e9lszer\u0171bb el\u0151sz\u00f6r valahov\u00e1 <span style=\"text-decoration: underline;\"><a title=\"Sz\u00fcks\u00e9gem lenne a v\u00e9geredm\u00e9nyre m\u00e1shol\" href=\"https:\/\/sosexcel.com\/exceltippek\/szuksegem-lenne-a-vegeredmenyre-mashol\/\" target=\"_blank\" rel=\"noopener noreferrer\">csak az \u00e9rt\u00e9keket beillesztened<\/a><\/span>, majd ut\u00e1na ezeket az adatokat \u00fajra m\u00e1solni \u00e9s ezut\u00e1n ford\u00edtsd meg a t\u00e1bl\u00e1zatot.<\/p>\n<p>Persze ut\u00f3lag is v\u00e1laszthatod a\u00a0<span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/formazas-ujrakezdese\/\" target=\"_blank\" rel=\"noopener noreferrer\">form\u00e1z\u00e1s t\u00f6rl\u00e9s\u00e9t<\/a><\/span>.<\/p>\n<p>Ha h\u00e9tr\u0151l h\u00e9tr\u0151l ism\u00e9tl\u0151d\u0151en kell t\u00e1bl\u00e1zatokat \u00e1talak\u00edtanod, akkor \u00e9rdekes lehet sz\u00e1modra a <span style=\"text-decoration: underline;\"><a href=\"https:\/\/exceltitok.hu\/power-query\" target=\"_blank\" rel=\"noopener\">Power Query<\/a><\/span> is, amivel automatiz\u00e1lhatod a t\u00e1bl\u00e1zat elforgat\u00e1s\u00e1t is.<\/p>\n<h2>Szeretn\u00e9l t\u00f6bbet tudni az Excelr\u0151l?<\/h2>\n<p>Ha szorgalmas vagy \u00e9s szeretsz k\u00f6nyvb\u0151l tanulni, akkor rendeld meg az\u00a0<span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel Kezd\u0151 &amp; Halad\u00f3 tank\u00f6nyv\u00fcnket<\/a><\/strong><\/span>.<\/p>\n<p>Ha szeretn\u00e9d rendszerezetten \u00e1tn\u00e9zni az Excel alapjait, \u00e9s szeretsz m\u00e1sokkal egy\u00fctt tanulni, akkor gyere az online\u00a0<strong><a href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">csoportos Excel k\u00e9pz\u00e9s\u00fcnkre<\/span><\/a><\/strong>! Ha ink\u00e1bb egy\u00e9nileg szeretn\u00e9l tanulni vagy a munk\u00e1ddal kapcsolatos t\u00e1bl\u00e1zatokat rendbe tenni, akkor v\u00e1runk <span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/exceltitok.hu\/oktatas\/\">egy\u00e9ni Excel oktat\u00e1sra<\/a><\/strong><\/span>.<\/p>\n<p>Vagy gyere a VIP Klubba, ahol\u00a0<strong>hasonl\u00f3 \u00e9rdekes megold\u00e1sokat tal\u00e1lsz<\/strong>, \u00e9s Te is b\u00e1rmikor k\u00e9rdezhetsz:\u00a0<strong><a href=\"https:\/\/exceltitok.hu\/vip-klub-2021\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">Excel VIP Klub<\/span><\/a><\/strong>.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>M\u00e1r 2 \u00f3r\u00e1t dolgoztam egy t\u00e1bl\u00e1zattal, amikor kider\u00fclt, hogy meg kellene ford\u00edtani az eg\u00e9szet, \u00fagy, hogy ami eddig az els\u0151 oszlopban volt, az ezent\u00fal az els\u0151 sorban legyen, \u00e9s persze minden adat mozogjon vele. V\u00e1lasz: L\u00e9tezik funkci\u00f3, amivel az oszlopokat \u00e1talak\u00edthatod sorokk\u00e1, \u00e9s a sorokat oszlopokk\u00e1 &#8211; ez pedig a Transzpon\u00e1l\u00e1s.<\/p>\n","protected":false},"author":1,"featured_media":9411,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[102,1],"tags":[86,87,88,16,23],"class_list":["post-295","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tablazat-keszitese","category-excel-tippek-gyakori-kerdesek","tag-excel2010","tag-excel2013","tag-excel2016","tag-masolas","tag-oszlop-sor-cella"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"L\u00e9tezik funkci\u00f3, amivel az oszlopokat \u00e1talak\u00edthatod sorokk\u00e1, \u00e9s a sorokat oszlopokk\u00e1 - ez pedig a Transzpon\u00e1l\u00e1s. Ak\u00e1r egy teljes t\u00e1bl\u00e1zatot is \u201emegford\u00edthatsz\u201d.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"L\u00e9tezik funkci\u00f3, amivel az oszlopokat \u00e1talak\u00edthatod sorokk\u00e1, \u00e9s a sorokat oszlopokk\u00e1 - ez pedig a Transzpon\u00e1l\u00e1s. Ak\u00e1r egy teljes t\u00e1bl\u00e1zatot is \u201emegford\u00edthatsz\u201d.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-12T14:54:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-31T16:34:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/04\/excel_transzponalas.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot?\",\"datePublished\":\"2013-09-12T14:54:16+00:00\",\"dateModified\":\"2022-01-31T16:34:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/\"},\"wordCount\":456,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/04\\\/excel_transzponalas.png\",\"keywords\":[\"Excel2010\",\"Excel2013\",\"Excel2016\",\"m\u00e1sol\u00e1s\",\"oszlop-sor-cella\"],\"articleSection\":[\"Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se\",\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/\",\"name\":\"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/04\\\/excel_transzponalas.png\",\"datePublished\":\"2013-09-12T14:54:16+00:00\",\"dateModified\":\"2022-01-31T16:34:14+00:00\",\"description\":\"L\u00e9tezik funkci\u00f3, amivel az oszlopokat \u00e1talak\u00edthatod sorokk\u00e1, \u00e9s a sorokat oszlopokk\u00e1 - ez pedig a Transzpon\u00e1l\u00e1s. Ak\u00e1r egy teljes t\u00e1bl\u00e1zatot is \u201emegford\u00edthatsz\u201d.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/04\\\/excel_transzponalas.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/04\\\/excel_transzponalas.png\",\"width\":1600,\"height\":900},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/meg-lehet-forditani-a-tablazatot\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\\\/\\\/exceltitok.hu\\\/\",\"https:\\\/\\\/www.facebook.com\\\/bernadett.koros\"],\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/author\\\/sos-excel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"L\u00e9tezik funkci\u00f3, amivel az oszlopokat \u00e1talak\u00edthatod sorokk\u00e1, \u00e9s a sorokat oszlopokk\u00e1 - ez pedig a Transzpon\u00e1l\u00e1s. Ak\u00e1r egy teljes t\u00e1bl\u00e1zatot is \u201emegford\u00edthatsz\u201d.","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:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/","og_locale":"hu_HU","og_type":"article","og_title":"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"L\u00e9tezik funkci\u00f3, amivel az oszlopokat \u00e1talak\u00edthatod sorokk\u00e1, \u00e9s a sorokat oszlopokk\u00e1 - ez pedig a Transzpon\u00e1l\u00e1s. Ak\u00e1r egy teljes t\u00e1bl\u00e1zatot is \u201emegford\u00edthatsz\u201d.","og_url":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2013-09-12T14:54:16+00:00","article_modified_time":"2022-01-31T16:34:14+00:00","og_image":[{"width":1600,"height":900,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/04\/excel_transzponalas.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot?","datePublished":"2013-09-12T14:54:16+00:00","dateModified":"2022-01-31T16:34:14+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/"},"wordCount":456,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/04\/excel_transzponalas.png","keywords":["Excel2010","Excel2013","Excel2016","m\u00e1sol\u00e1s","oszlop-sor-cella"],"articleSection":["Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se","Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/","url":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/","name":"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/04\/excel_transzponalas.png","datePublished":"2013-09-12T14:54:16+00:00","dateModified":"2022-01-31T16:34:14+00:00","description":"L\u00e9tezik funkci\u00f3, amivel az oszlopokat \u00e1talak\u00edthatod sorokk\u00e1, \u00e9s a sorokat oszlopokk\u00e1 - ez pedig a Transzpon\u00e1l\u00e1s. Ak\u00e1r egy teljes t\u00e1bl\u00e1zatot is \u201emegford\u00edthatsz\u201d.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/04\/excel_transzponalas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/04\/excel_transzponalas.png","width":1600,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot?"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=295"}],"version-history":[{"count":24,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/295\/revisions"}],"predecessor-version":[{"id":9415,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/295\/revisions\/9415"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/9411"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}