{"id":13200,"date":"2023-04-09T14:47:08","date_gmt":"2023-04-09T14:47:08","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=13200"},"modified":"2023-10-12T18:42:55","modified_gmt":"2023-10-12T21:42:55","slug":"la-funcion-transponer-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/","title":{"rendered":"LA FUNCI\u00d3N TRANSPONER EN EXCEL"},"content":{"rendered":"<p>&nbsp;<\/p>\n<h2>\u00bfPARA QU\u00c9 SIRVE LA FUNCI\u00d3N TRASNPONER EN EXCEL?<\/h2>\n<p>La funci\u00f3n <em><strong>TRANSPONER<\/strong><\/em> en Excel permite cambiar la orientaci\u00f3n de una matriz de datos, de modo que las filas se conviertan en columnas y las columnas en filas. La funci\u00f3n <em><strong>TRANSPONER<\/strong> <\/em>solo se utiliza en f\u00f3rmulas de matriz.<\/p><div id=\"excel-134853819\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>Esta funci\u00f3n la podemos utilizar en una variedad de situaciones. Por ejemplo, si tenemos una tabla con datos organizados por fila, pero necesitamos analizarlos por columna, la funci\u00f3n <strong><em>TRANSPONER<\/em><\/strong> puede cambiar la orientaci\u00f3n de los datos para que sean m\u00e1s f\u00e1ciles de analizar, leer y comprender.<\/p>\n<p>Otra forma en que la funci\u00f3n <em><strong>TRANSPONER<\/strong> <\/em>puede ser \u00fatil es para la creaci\u00f3n de gr\u00e1ficos. En algunos casos, los gr\u00e1ficos son m\u00e1s f\u00e1ciles de leer si los datos est\u00e1n organizados en una columna.<\/p>\n<p>Tambi\u00e9n se puede utilizar para fusionar datos de diferentes tablas. Por ejemplo, si tenemos dos tablas de datos con informaci\u00f3n similar, pero organizadas en filas diferentes, podemos utilizar esta funci\u00f3n para combinarlas en una sola tabla para realizar los an\u00e1lisis de datos y facilitar su manipulaci\u00f3n.<\/p>\n<hr \/>\n<h2 style=\"text-align: center;\"><strong>SINTAXIS DE LA FUNCI\u00d3N TRANSPONER<\/strong><\/h2>\n<h3 style=\"text-align: center;\">=TRANSPONER(matriz)<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-13202 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer.png\" alt=\"LA FUNCI\u00d3N TRANSPONER EN EXCEL\" width=\"576\" height=\"225\" \/><\/p>\n<hr \/>\n<h2>ARGUMENTOS DE LA FUNCI\u00d3N TRANSPONER<\/h2>\n<p style=\"text-align: left;\">La sintaxis de la funci\u00f3n <em><strong>TRANSPONER<\/strong><\/em> tiene el argumento siguiente:<\/p>\n<ul>\n<li><strong>matriz (Obligatorio):<\/strong> Una matriz o rango de celdas de una hoja de c\u00e1lculo que desea transponer.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">En la transposici\u00f3n de una matriz la primera fila de la matriz ser\u00e1 la primera columna de la nueva matriz, la segunda fila de la matriz como segunda columna de la nueva matriz, y as\u00ed sucesivamente.<\/p>\n<h2>EJEMPLO DE LA FUNCI\u00d3N TRANSPONER<\/h2>\n<p>Reorganizaremos una tabla con datos de venta de libros:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13206\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/trasnpo.png\" alt=\"\" width=\"347\" height=\"216\" \/><\/p>\n<p><strong>PASO 1:<\/strong> En primer lugar, seleccionamos varias celdas en blanco, donde queremos que parezca la segunda matriz, asegur\u00e1ndonos de seleccionar el mismo n\u00famero de celdas que la matriz original. En nuestro caso tenemos 5 celdas organizadas en vertical, as\u00ed que seleccionaremos 5 celdas en horizontal.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13207\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer-1.png\" alt=\"\" width=\"843\" height=\"244\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer-1.png 843w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer-1-768x222.png 768w\" sizes=\"auto, (max-width: 843px) 100vw, 843px\" \/><\/p>\n<p><strong>PASO 2:<\/strong> Una vez seleccionadas las celdas, aplicamos la funci\u00f3n seguido del rango de las celdas que deseamos transponer; en este ejemplo, queremos transponer las celdas de A3:D7; pero no presionamos ENTER todav\u00eda.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13208\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer-2.png\" alt=\"\" width=\"839\" height=\"296\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer-2.png 839w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer-2-768x271.png 768w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/p>\n<p><strong>PASO 3:<\/strong> Por \u00faltimo, presionamos CTRL + SHIFT + ACEPTAR \u00bfPor qu\u00e9? Porque, como hab\u00edamos visto m\u00e1s arriba, la funci\u00f3n TRANSPONER solo se utiliza en f\u00f3rmulas de matriz y esta es la forma de terminar una f\u00f3rmula de matriz.<\/p>\n<p>Finalmente tenemos nuestra matriz transpuesta:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13209\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer-3.png\" alt=\"\" width=\"834\" height=\"231\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer-3.png 834w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/transponer-3-768x213.png 768w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/p>\n<h2>CONCLUSI\u00d3N<\/h2>\n<p>La funci\u00f3n <em><strong>TRANSPONER<\/strong><\/em> en Excel es una herramienta poderosa que puede ayudarnos a manipular y analizar datos de una manera m\u00e1s efectiva. Ya sea que necesitemos presentar datos de una manera diferente, crear gr\u00e1ficos m\u00e1s f\u00e1ciles de leer o fusionar datos de diferentes tablas, esta funci\u00f3n puede ayudarnos a ahorrar tiempo y esfuerzo en los an\u00e1lisis de datos.<\/p>\n<hr \/>\n<blockquote><p><strong>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> <\/span>e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\" target=\"_blank\" rel=\"noopener\">Instagram<\/a><\/span>.<\/strong><\/p>\n<p><strong>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/strong><\/p>\n<p><strong>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <\/strong><a href=\"https:\/\/excelfull.com\/\" target=\"_blank\" rel=\"noopener\"><strong>Curso de Excel Online<\/strong><\/a><\/p><\/blockquote>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; \u00bfPARA QU\u00c9 SIRVE LA &#8230; <a title=\"LA FUNCI\u00d3N TRANSPONER EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/\" aria-label=\"Leer m\u00e1s sobre LA FUNCI\u00d3N TRANSPONER EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":13201,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[569,328,549,556],"tags":[575,596],"class_list":["post-13200","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-busqueda-y-referencia","category-excel","category-excel-intermedio","category-funciones-especiales","tag-funciones","tag-transponer","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>LA FUNCI\u00d3N TRANSPONER EN EXCEL - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"La funci\u00f3n TRANSPONER en Excel permite cambiar la orientaci\u00f3n de una matriz, de modo que las filas se conviertan en columnas y viceversa.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LA FUNCI\u00d3N TRANSPONER EN EXCEL - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n TRANSPONER en Excel permite cambiar la orientaci\u00f3n de una matriz, de modo que las filas se conviertan en columnas y viceversa.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-09T14:47:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-12T21:42:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LA FUNCI\u00d3N TRANSPONER EN EXCEL\",\"datePublished\":\"2023-04-09T14:47:08+00:00\",\"dateModified\":\"2023-10-12T21:42:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/\"},\"wordCount\":525,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png\",\"keywords\":[\"funciones\",\"transponer\"],\"articleSection\":[\"B\u00fasqueda y Referencia\",\"Excel\",\"Excel Intermedio\",\"Funciones Especiales\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/\",\"name\":\"LA FUNCI\u00d3N TRANSPONER EN EXCEL - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png\",\"datePublished\":\"2023-04-09T14:47:08+00:00\",\"dateModified\":\"2023-10-12T21:42:55+00:00\",\"description\":\"La funci\u00f3n TRANSPONER en Excel permite cambiar la orientaci\u00f3n de una matriz, de modo que las filas se conviertan en columnas y viceversa.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"LA FUNCI\u00d3N TRANSPONER EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LA FUNCI\u00d3N TRANSPONER EN EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"LA FUNCI\u00d3N TRANSPONER EN EXCEL - EXCELFULL.COM","description":"La funci\u00f3n TRANSPONER en Excel permite cambiar la orientaci\u00f3n de una matriz, de modo que las filas se conviertan en columnas y viceversa.","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:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"LA FUNCI\u00d3N TRANSPONER EN EXCEL - EXCELFULL.COM","og_description":"La funci\u00f3n TRANSPONER en Excel permite cambiar la orientaci\u00f3n de una matriz, de modo que las filas se conviertan en columnas y viceversa.","og_url":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-04-09T14:47:08+00:00","article_modified_time":"2023-10-12T21:42:55+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LA FUNCI\u00d3N TRANSPONER EN EXCEL","datePublished":"2023-04-09T14:47:08+00:00","dateModified":"2023-10-12T21:42:55+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/"},"wordCount":525,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png","keywords":["funciones","transponer"],"articleSection":["B\u00fasqueda y Referencia","Excel","Excel Intermedio","Funciones Especiales"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/","url":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/","name":"LA FUNCI\u00d3N TRANSPONER EN EXCEL - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png","datePublished":"2023-04-09T14:47:08+00:00","dateModified":"2023-10-12T21:42:55+00:00","description":"La funci\u00f3n TRANSPONER en Excel permite cambiar la orientaci\u00f3n de una matriz, de modo que las filas se conviertan en columnas y viceversa.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LA-FUNCION-TRANSPONER-EN-EXCEL.png","width":1280,"height":720,"caption":"LA FUNCI\u00d3N TRANSPONER EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/la-funcion-transponer-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"LA FUNCI\u00d3N TRANSPONER EN EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=13200"}],"version-history":[{"count":8,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13200\/revisions"}],"predecessor-version":[{"id":14368,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13200\/revisions\/14368"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/13201"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=13200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=13200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=13200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}