{"id":14241,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/transponer\/"},"modified":"2021-02-26T09:00:28","modified_gmt":"2021-02-26T09:00:28","slug":"transpose","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/transpose\/","title":{"rendered":"TRANSPONER"},"content":{"rendered":"

Descripci\u00f3n y Uso de TRANSPONER<\/h2>\n

La funci\u00f3n TRANSPONER, disponible tanto en Excel como en Google Sheets, permite modificar la orientaci\u00f3n de un rango de celdas, transformando filas en columnas y viceversa. Esta herramienta es especialmente valiosa en el manejo de bases de datos y tablas cuando es necesario cambiar la disposici\u00f3n de los datos para facilitar el an\u00e1lisis o la elaboraci\u00f3n de informes.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n TRANSPONER es la siguiente:<\/p>\n

=TRANSPOSE(array)<\/code><\/pre>\n
    \n
  • array<\/strong>: Rango de celdas que deseas transponer.<\/li>\n<\/ul>\n
    Consideremos el siguiente ejemplo en Excel o Google Sheets:<\/p>\n\n\n\n\n
    A<\/td>\nB<\/td>\nC<\/td>\n<\/tr>\n
    1<\/td>\n2<\/td>\n3<\/td>\n<\/tr>\n
    4<\/td>\n5<\/td>\n6<\/td>\n<\/tr>\n<\/table>\n
    Para transponer esta tabla, selecciona un nuevo \u00e1rea en la hoja y escribe:<\/p>\n
    =TRANSPOSE(A1:C2)<\/code><\/pre>\n
    Tras presionar Enter, manteniendo seleccionado el rango, obtendr\u00e1s la siguiente tabla transpuesta:<\/p>\n\n\n\n\n
    A<\/td>\n4<\/td>\n<\/tr>\n
    B<\/td>\n5<\/td>\n<\/tr>\n
    C<\/td>\n6<\/td>\n<\/tr>\n<\/table>\n
    Casos pr\u00e1cticos<\/h2>\n
    Creaci\u00f3n de informes din\u00e1micos<\/h2>\n
    Imagina que necesitas generar un informe en el cual los nombres de los empleados, que usualmente se listan en columna, deben aparecer en la fila superior para facilitar la comparaci\u00f3n de sus rendimientos mensuales. Para ello, emplear\u00e1s la funci\u00f3n TRANSPONER para modificar la orientaci\u00f3n de la lista.<\/p>\n
    Inicialmente, la tabla se ver\u00eda as\u00ed:<\/p>\n\n\n\n\n
    Juan<\/td>\n<\/tr>\n
    Maria<\/td>\n<\/tr>\n
    Carlos<\/td>\n<\/tr>\n<\/table>\n
    Utiliza TRANSPONER de la siguiente manera:<\/p>\n
    =TRANSPOSE(A1:A3)<\/code><\/pre>\n
    Resultado:<\/p>\n\n\n
    Juan<\/td>\nMaria<\/td>\nCarlos<\/td>\n<\/tr>\n<\/table>\n
    Posteriormente, puedes a\u00f1adir columnas adyacentes para incluir datos espec\u00edficos sobre el desempe\u00f1o mensual de cada empleado.<\/p>\n
    Comparaci\u00f3n de Datos Anuales<\/h2>\n
    Otro uso com\u00fan de TRANSPONER es para comparar datos anuales de ventas o gastos que est\u00e1n detallados en filas y convertirlos en una disposici\u00f3n de columnas, facilitando as\u00ed el an\u00e1lisis visual y estad\u00edstico.<\/p>\n
    Supongamos que dispones de la siguiente tabla:<\/p>\n\n\n\n\n
    2019<\/td>\n1000<\/td>\n<\/tr>\n
    2020<\/td>\n1500<\/td>\n<\/tr>\n
    2021<\/td>\n1800<\/td>\n<\/tr>\n<\/table>\n
    Para analizar los datos en formato de columnas, usar\u00edas:<\/p>\n
    =TRANSPOSE(A1:B3)<\/code><\/pre>\n
    El resultado se mostrar\u00eda as\u00ed:<\/p>\n\n\n\n
    2019<\/td>\n2020<\/td>\n2021<\/td>\n<\/tr>\n
    1000<\/td>\n1500<\/td>\n1800<\/td>\n<\/tr>\n<\/table>\n
    Este formato facilita la inclusi\u00f3n de gr\u00e1ficos comparativos y otras herramientas de an\u00e1lisis.<\/p>\n
     Este HTML brinda una estructura clara y did\u00e1ctica, adecuada para materiales de instrucci\u00f3n en l\u00ednea, cumpliendo con las especificaciones requeridas y mejorando la comprensi\u00f3n sobre c\u00f3mo utilizar la funci\u00f3n TRANSPONER en aplicaciones de hojas de c\u00e1lculo.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la transposici\u00f3n de una matriz<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[537],"tags":[],"class_list":["post-14241","post","type-post","status-publish","format-standard","hentry","category-busqueda-y-referencia"],"acf":[],"yoast_head":"\nFunci\u00f3n TRANSPOSE (TRANSPONER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n TRANSPOSE (TRANSPONER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/transpose\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n TRANSPOSE (TRANSPONER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n TRANSPOSE (TRANSPONER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/transpose\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:00:28+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n TRANSPOSE (TRANSPONER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/transpose\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/transpose\/\",\"name\":\"Funci\u00f3n TRANSPOSE (TRANSPONER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T09:00:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n TRANSPOSE (TRANSPONER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/transpose\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/transpose\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/transpose\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"B\u00fasqueda y referencia\",\"item\":\"https:\/\/functiontranslator.com\/es\/busqueda-y-referencia\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TRANSPONER\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n TRANSPOSE (TRANSPONER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n TRANSPOSE (TRANSPONER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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:\/\/functiontranslator.com\/es\/transpose\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n TRANSPOSE (TRANSPONER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n TRANSPOSE (TRANSPONER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/transpose\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T09:00:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n TRANSPOSE (TRANSPONER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/transpose\/","url":"https:\/\/functiontranslator.com\/es\/transpose\/","name":"Funci\u00f3n TRANSPOSE (TRANSPONER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T09:00:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n TRANSPOSE (TRANSPONER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/transpose\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/transpose\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/transpose\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"B\u00fasqueda y referencia","item":"https:\/\/functiontranslator.com\/es\/busqueda-y-referencia\/"},{"@type":"ListItem","position":3,"name":"TRANSPONER"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14241"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14241\/revisions"}],"predecessor-version":[{"id":30370,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14241\/revisions\/30370"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}