{"id":346,"date":"2023-11-02T03:59:47","date_gmt":"2023-11-02T03:59:47","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/"},"modified":"2023-12-25T10:24:08","modified_gmt":"2023-12-25T10:24:08","slug":"columna-a-fila","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/","title":{"rendered":"\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1777580581\"><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>En Excel, si desea cambiar columnas a filas, puede usar la funci\u00f3n TRANSPONER. Con esta funci\u00f3n, todo lo que necesita hacer es seleccionar un rango con celdas equivalentes desde las cuales desea agregar los datos modificados, consultar el rango y usar CONTROL + SHIFT + ENTER.<\/p>\n<p> En el siguiente ejemplo, tiene una lista de nombres y edades. Y necesitamos cambiar estas dos columnas a filas. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67607\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\" sizes=\"auto, \" srcset=\"\" alt=\"lista-de-nombres-y-edades\" width=\"315\" height=\"324\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Pasos para cambiar columnas a filas<\/h2>\n<ol type=\"1\">\n<li> Primero, en el rango D1:H2, ingrese la funci\u00f3n TRANSPONER.<\/li>\n<li> Luego consulte el rango A1:B6.<\/li>\n<li> Despu\u00e9s de eso, escriba el par\u00e9ntesis de cierre.<\/li>\n<li> Al final, mantenga presionado CRTL + SHIFT y presione ENTER. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67608\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-colonnes-de-fonction-de-transposition-en-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"transponer-funci\u00f3n-columnas-a-filas\" width=\"584\" height=\"298\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TRANSPOSE(A1:B6)<\/code><\/pre>\n<p> Como puede ver en el ejemplo anterior, hemos convertido con \u00e9xito nuestras columnas en filas.<\/p>\n<p> Para comprender c\u00f3mo funciona la funci\u00f3n de transposici\u00f3n, debe comprender que toma la matriz (rango) que especifique y luego convierte celdas verticales en celdas horizontales y viceversa.<\/p>\n<p> Pero hay una cosa de la que debes cuidar: debes seleccionar la misma cantidad de celdas de maneras opuestas. Y necesitas usar <strong>CONTROL + SHIFT + ENTER<\/strong> para que esta funci\u00f3n funcione.<\/p>\n<p> Aqu\u00ed hay una cosa m\u00e1s, una vez que creas TRANSPOSE funciona din\u00e1micamente, una vez que cambias un valor en cualquiera de las celdas de las celdas originales, ese valor tambi\u00e9n se cambiar\u00e1 en el rango transpuesto.<\/p>\n<p> Y si desea cambiar el rango transpuesto a valores y no desea conectarlo con los valores originales, puede pegar un valor especial o seleccionar el rango usando el m\u00e9todo abreviado de teclado Ctrl + C y luego Alt + V \u21e2 v. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/changer-les-colonnes-en-lignes.xlsx\" rel=\"nofollow\">Descargar<\/a><\/div>\n<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\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/capitalizar-la-primera-letra\/\">Poner en may\u00fascula la primera letra en Excel.<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/caso-de-sentencia\/\">Cambiar a caso de oraci\u00f3n en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/devolver-la-coma-del-primer-nombre-entre\/\">Devuelve el nombre y apellido y agrega un comando<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cambiar-caso-de-texto\/\">Cambiar may\u00fasculas y min\u00fasculas del texto (may\u00fasculas, min\u00fasculas, propia)<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, si desea cambiar columnas a filas, puede usar la funci\u00f3n TRANSPONER. Con esta funci\u00f3n, todo lo que necesita hacer es seleccionar un rango con celdas equivalentes desde las cuales desea agregar los datos modificados, consultar el rango y usar CONTROL + SHIFT + ENTER. En el siguiente ejemplo, tiene una lista de nombres [&hellip;]<\/p>\n","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-346","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>\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?<\/title>\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\/es\/columna-a-fila\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?\" \/>\n<meta property=\"og:description\" content=\"En Excel, si desea cambiar columnas a filas, puede usar la funci\u00f3n TRANSPONER. Con esta funci\u00f3n, todo lo que necesita hacer es seleccionar un rango con celdas equivalentes desde las cuales desea agregar los datos modificados, consultar el rango y usar CONTROL + SHIFT + ENTER. En el siguiente ejemplo, tiene una lista de nombres [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/\",\"name\":\"\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\",\"datePublished\":\"2023-11-02T03:59:47+00:00\",\"dateModified\":\"2023-12-25T10:24:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo cambiar una columna en una fila (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:\/\/exceladvisor.org\/es\/columna-a-fila\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?","og_description":"En Excel, si desea cambiar columnas a filas, puede usar la funci\u00f3n TRANSPONER. Con esta funci\u00f3n, todo lo que necesita hacer es seleccionar un rango con celdas equivalentes desde las cuales desea agregar los datos modificados, consultar el rango y usar CONTROL + SHIFT + ENTER. En el siguiente ejemplo, tiene una lista de nombres [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:08+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/","url":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/","name":"\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png","datePublished":"2023-11-02T03:59:47+00:00","dateModified":"2023-12-25T10:24:08+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/columna-a-fila\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/columna-a-fila\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=346"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/346\/revisions"}],"predecessor-version":[{"id":901,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/346\/revisions\/901"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}