{"id":345,"date":"2023-11-02T03:59:47","date_gmt":"2023-11-02T03:59:47","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/"},"modified":"2023-12-06T11:34:29","modified_gmt":"2023-12-06T11:34:29","slug":"coluna-para-linha","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/","title":{"rendered":"Como alterar coluna em linha (vice-versa)?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1549605440\"><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><div class=\"excel-before-content\" id=\"excel-1631078189\"><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>No Excel, se quiser transformar colunas em linhas, voc\u00ea pode usar a fun\u00e7\u00e3o TRANSPOSE. Com esta fun\u00e7\u00e3o, basta selecionar um intervalo com c\u00e9lulas equivalentes a partir do qual deseja adicionar os dados alterados, consultar o intervalo e usar CONTROL + SHIFT + ENTER.<\/p><p> No exemplo a seguir, voc\u00ea tem uma lista de nomes e idades. E precisamos transformar essas duas colunas em linhas. <\/p><div class=\"wp-block-image\"><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 nomes e idades\" width=\"315\" height=\"324\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Etapas para transformar colunas em linhas<\/h2><ol type=\"1\"><li> Primeiro, no intervalo D1:H2, insira a fun\u00e7\u00e3o TRANSPOSE.<\/li><li> Em seguida, consulte o intervalo A1:B6.<\/li><li> Depois disso, digite os par\u00eanteses de fechamento.<\/li><li> No final, pressione e segure CRTL + SHIFT e pressione ENTER. <\/li><\/ol><div class=\"wp-block-image\"><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=\"transpor-fun\u00e7\u00e3o-colunas-para-linhas\" width=\"584\" height=\"298\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TRANSPOSE(A1:B6)<\/code><\/pre><p> Como voc\u00ea pode ver no exemplo acima, convertemos com sucesso nossas colunas em linhas.<\/p><p> Para entender como funciona a fun\u00e7\u00e3o de transposi\u00e7\u00e3o, voc\u00ea precisa entender que ela pega o array (intervalo) que voc\u00ea especifica e depois converte c\u00e9lulas verticais em c\u00e9lulas horizontais e vice-versa.<\/p><p> Mas h\u00e1 uma coisa que voc\u00ea precisa cuidar: voc\u00ea precisa selecionar o mesmo n\u00famero de c\u00e9lulas de maneiras opostas. E voc\u00ea precisa usar <strong>CONTROL + SHIFT + ENTER<\/strong> para que esta fun\u00e7\u00e3o funcione.<\/p><p> Aqui est\u00e1 mais uma coisa, uma vez que voc\u00ea cria TRANSPOSE funciona dinamicamente, uma vez que voc\u00ea altera um valor em qualquer uma das c\u00e9lulas das c\u00e9lulas originais, esse valor tamb\u00e9m ser\u00e1 alterado no intervalo transposto.<\/p><p> E se voc\u00ea deseja alterar o intervalo transposto para valores e n\u00e3o deseja conect\u00e1-lo aos valores originais, voc\u00ea pode colar um valor especial ou selecionar o intervalo usando o atalho de teclado Ctrl + C e depois Alt + V \u21e2 V. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtenha o arquivo Excel<\/h2> <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\">Download<\/a><\/div><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\/pt\/formulas\/\">Lista de f\u00f3rmulas do Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/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\/pt\/colocar-a-primeira-letra-em-maiuscula\/\">Coloque a primeira letra em mai\u00fascula no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/caso-de-frase\/\">Mudar para mai\u00fasculas e min\u00fasculas no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/retorne-os-primeiros-nomes-virgula-entre\/\">Retorne o nome e o sobrenome e adicione um comando<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/alterar-maiusculas-e-minusculas-do-texto\/\">Alterar mai\u00fasculas e min\u00fasculas do texto (mai\u00fasculas, min\u00fasculas, adequadas)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-345","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>Como mudar coluna para linha (vice-versa) no Excel?<\/title>\n<meta name=\"description\" content=\"Nesta f\u00f3rmula, voc\u00ea aprender\u00e1 como usar uma f\u00f3rmula para alterar dados de uma coluna para uma linha no Excel de maneira f\u00e1cil.\" \/>\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\/pt\/coluna-para-linha\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como mudar coluna para linha (vice-versa) no Excel?\" \/>\n<meta property=\"og:description\" content=\"Nesta f\u00f3rmula, voc\u00ea aprender\u00e1 como usar uma f\u00f3rmula para alterar dados de uma coluna para uma linha no Excel de maneira f\u00e1cil.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:34:29+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=\"Tempo estimado de leitura\" \/>\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\/pt\/coluna-para-linha\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/\",\"name\":\"Como mudar coluna para linha (vice-versa) no Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/#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-06T11:34:29+00:00\",\"description\":\"Nesta f\u00f3rmula, voc\u00ea aprender\u00e1 como usar uma f\u00f3rmula para alterar dados de uma coluna para uma linha no Excel de maneira f\u00e1cil.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/#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\/pt\/coluna-para-linha\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como alterar coluna em linha (vice-versa)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como mudar coluna para linha (vice-versa) no Excel?","description":"Nesta f\u00f3rmula, voc\u00ea aprender\u00e1 como usar uma f\u00f3rmula para alterar dados de uma coluna para uma linha no Excel de maneira f\u00e1cil.","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\/pt\/coluna-para-linha\/","og_locale":"pt_PT","og_type":"article","og_title":"Como mudar coluna para linha (vice-versa) no Excel?","og_description":"Nesta f\u00f3rmula, voc\u00ea aprender\u00e1 como usar uma f\u00f3rmula para alterar dados de uma coluna para uma linha no Excel de maneira f\u00e1cil.","og_url":"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:34:29+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":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/","url":"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/","name":"Como mudar coluna para linha (vice-versa) no Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/#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-06T11:34:29+00:00","description":"Nesta f\u00f3rmula, voc\u00ea aprender\u00e1 como usar uma f\u00f3rmula para alterar dados de uma coluna para uma linha no Excel de maneira f\u00e1cil.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/coluna-para-linha\/#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\/pt\/coluna-para-linha\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como alterar coluna em linha (vice-versa)?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=345"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/345\/revisions"}],"predecessor-version":[{"id":830,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/345\/revisions\/830"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}