{"id":1747,"date":"2024-07-15T09:46:43","date_gmt":"2024-07-15T09:46:43","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=1747"},"modified":"2024-07-15T13:36:48","modified_gmt":"2024-07-15T13:36:48","slug":"transpor-funcao-nao-trabalhando-no-excel","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel","title":{"rendered":"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Voc\u00ea j\u00e1 tentou usar a <strong>fun\u00e7\u00e3o TRANSPOSE<\/strong> no Microsoft Excel e descobriu que ela n\u00e3o funciona conforme o esperado? Pode ser extremamente frustrante, especialmente quando voc\u00ea tem um prazo apertado. N\u00e3o se preocupe; voc\u00ea est\u00e1 no lugar certo. Neste blog \u00fatil, explorarei por que o <strong>Excel TRANSPOSE n\u00e3o funciona<\/strong> para voc\u00ea e fornecerei m\u00e9todos claros e passo a passo para colocar as coisas de volta nos trilhos.<!--more--><\/p>\n<h2 style=\"text-align: left;\"><strong>Sobre a fun\u00e7\u00e3o TRANSPOSE do Excel em detalhes<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>TRANSPOSE<\/strong> \u00e9 uma fun\u00e7\u00e3o do Microsoft Excel que inverte a orienta\u00e7\u00e3o de determinados dados ou matriz de intervalo de c\u00e9lulas. Com a ajuda desta fun\u00e7\u00e3o, voc\u00ea pode facilmente alterar o intervalo horizontal para vertical ou os intervalos verticais para horizontal. Isso significa que voc\u00ea pode transformar os dados das linhas em colunas ou os dados das colunas em linhas.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4817 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/1.png\" alt=\"Microsoft Excel Transpose n\u00e3o funciona\" width=\"705\" height=\"434\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000;\"><strong>Vejamos um exemplo<\/strong><\/span>: suponha que algu\u00e9m lhe forne\u00e7a um arquivo Excel cujos dados s\u00e3o muito dif\u00edceis de entender e, portanto, voc\u00ea queira fazer alguns arranjos de dados nele. Bem, voc\u00ea pode executar facilmente essa tarefa dif\u00edcil usando a fun\u00e7\u00e3o TRANSPOSE integrada do Excel.<\/p>\n<h2 style=\"text-align: left;\"><strong>Por que o Transpose n\u00e3o funciona no Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Estes s\u00e3o alguns motivos pelos quais a fun\u00e7\u00e3o de transposi\u00e7\u00e3o do Excel n\u00e3o funciona:<\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\"><strong>Sele\u00e7\u00e3o de dados incorreta<\/strong> \u2013 Se sua sele\u00e7\u00e3o contiver c\u00e9lulas em branco ou n\u00e3o abranger todos os dados necess\u00e1rios, isso pode levar a esse problema.<\/li>\n<li style=\"text-align: left;\"><strong>Tipos de dados e problemas de formata\u00e7\u00e3o<\/strong> &#8211; Quando sua planilha do Excel cont\u00e9m tipos de dados mistos, como texto, n\u00fameros, datas, o Excel pode ter dificuldade para transp\u00f4-los corretamente.<\/li>\n<li style=\"text-align: left;\"><strong>C\u00e9lulas mescladas<\/strong> &#8211; As c\u00e9lulas mescladas podem at\u00e9 interromper a fun\u00e7\u00e3o TRANSPOSE.<\/li>\n<li style=\"text-align: left;\"><strong>Linhas ou colunas ocultas<\/strong> \u2013 o MS Excel pode tentar TRANSPOSE dados ocultos (linhas e colunas), levando a resultados imprevis\u00edveis.<\/li>\n<\/ol>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Leia tamb\u00e9m<\/span>: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes\" target=\"_blank\" rel=\"noopener\">Fun\u00e7\u00f5es de matriz do Excel \u2013 Como criar uma matriz no Excel como um profissional?<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Como corrigir o problema de n\u00e3o funcionamento do Microsoft Excel Transpose?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Sem perder mais tempo, vamos saber como voc\u00ea pode resolver facilmente esse problema de n\u00e3o funcionamento da fun\u00e7\u00e3o de transposi\u00e7\u00e3o do Excel.<\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 1: TRANSPOSE usando copiar e colar<\/strong><\/h3>\n<p style=\"text-align: justify;\">Se a fun\u00e7\u00e3o de <strong>transposi\u00e7\u00e3o do Excel n\u00e3o funcionar<\/strong>, outra maneira mais f\u00e1cil de TRANSPOSE os dados \u00e9 usando o recurso de copiar e colar. Transpose Data n\u00e3o possui nenhum v\u00ednculo com o conjunto de dados original. Portanto, se voc\u00ea n\u00e3o precisa do conjunto original de dados, basta exclu\u00ed-lo.<\/p>\n<p style=\"text-align: justify;\">No entanto, se alguma altera\u00e7\u00e3o for feita no conjunto de dados original, ela n\u00e3o ser\u00e1 refletida nos dados transpostos, pois \u00e9 apenas uma c\u00f3pia.<\/p>\n<p style=\"text-align: justify;\">Vamos TRANSPOSE dados do Excel mesmo quando sua <strong>transposi\u00e7\u00e3o n\u00e3o funciona no Excel.<\/strong><\/p>\n<p style=\"text-align: justify;\">No exemplo mostrado, voc\u00ea ver\u00e1 uma lista de pa\u00edses junto com os valores monet\u00e1rios. Siga as etapas abaixo para TRANSPOSE as colunas da planilha do Excel em linhas.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4818 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/2.png\" alt=\"Microsoft Excel Transpose n\u00e3o funciona\" width=\"660\" height=\"428\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Primeiramente voc\u00ea deve escolher os valores contidos na coluna \u201c<strong>Pa\u00eds<\/strong>\u201d.<\/li>\n<li style=\"text-align: left;\">Agora pressione <strong>CTRL + C<\/strong> para copiar os valores da coluna.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4819 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/3.png\" alt=\"Microsoft Excel Transpose n\u00e3o funciona\" width=\"690\" height=\"467\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Em seguida, clique na <strong>c\u00e9lula vazia<\/strong> onde deseja TRANSPOSE os dados do Excel.<\/li>\n<li style=\"text-align: left;\">Agora toque com o bot\u00e3o direito naquela c\u00e9lula vazia.<\/li>\n<li style=\"text-align: left;\">Nas op\u00e7\u00f5es de colagem, escolha a op\u00e7\u00e3o <strong>TRANSPOSE<\/strong>:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4820 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/4.png\" alt=\"Microsoft Excel Transpose n\u00e3o funciona\" width=\"440\" height=\"311\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Quando voc\u00ea posiciona o mouse sobre esta op\u00e7\u00e3o de <strong>transposi\u00e7\u00e3o<\/strong>. Voc\u00ea poder\u00e1 ver instantaneamente a visualiza\u00e7\u00e3o dos dados transpostos do Excel.<\/li>\n<li style=\"text-align: left;\">Depois de tocar no \u00edcone de transposi\u00e7\u00e3o, voc\u00ea ver\u00e1 que uma nova linha aparece em sua planilha Excel.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4821 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/5.png\" alt=\"Microsoft Excel Transpose n\u00e3o funciona\" width=\"768\" height=\"378\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Execute a mesma etapa com outras colunas do Excel. Fazer isso transformar\u00e1 todas as suas colunas em linhas.<\/li>\n<li style=\"text-align: left;\">Voc\u00ea pode excluir o conjunto de dados mais antigo que possui antes de executar a etapa de transposi\u00e7\u00e3o.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4822 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/6.png\" alt=\"Microsoft Excel Transpose n\u00e3o funciona\" width=\"651\" height=\"446\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Selecione as c\u00e9lulas que deseja excluir e clique com o bot\u00e3o direito nelas. No menu de contexto, escolha a op\u00e7\u00e3o <strong>excluir<\/strong>.<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 2: TRANSPOSE uma tabela do Excel para outra tabela do Excel<\/strong><\/h3>\n<p style=\"text-align: justify;\">Outra forma de realizar a opera\u00e7\u00e3o de transposi\u00e7\u00e3o no Excel sem usar a fun\u00e7\u00e3o de transposi\u00e7\u00e3o \u00e9 usando a consulta avan\u00e7ada.<\/p>\n<p style=\"text-align: justify;\">Bem, o truque \u00e9 usar a consulta Power que j\u00e1 possui sua pr\u00f3pria fun\u00e7\u00e3o de transposi\u00e7\u00e3o privada.<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000;\"><strong>Nota<\/strong><\/span>: Se voc\u00ea estiver usando o Excel 2013\/2010, ser\u00e1 necess\u00e1rio instalar o Power Query como um suplemento. mas se voc\u00ea estiver usando a vers\u00e3o Excel 2016, n\u00e3o precisar\u00e1 fazer isso.<\/p>\n<\/div><\/div>\n<p style=\"text-align: justify;\">Etapas para <strong>TRANSPOSE dados do Excel no Excel 2016<\/strong> usando consulta avan\u00e7ada:<\/p>\n<ul>\n<li style=\"text-align: left;\">Fa\u00e7a a sele\u00e7\u00e3o de sua tabela de origem e toque na guia <strong>Dados<\/strong> na faixa do Excel. Depois entre no grupo <strong>Get &amp; Transform Data<\/strong> e escolha a <strong>tabela From<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1758\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-6.png\" alt=\"Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando 6\" width=\"355\" height=\"126\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-6.png 355w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-6-300x106.png 300w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora, na caixa de di\u00e1logo aberta Criar tabela, verifique se o intervalo de exibi\u00e7\u00e3o est\u00e1 correto ap\u00f3s a garantia completa tocar na op\u00e7\u00e3o OK.\u00a0Voc\u00ea deseja que na tela uma caixa de di\u00e1logo do editor de consultas seja aberta.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1757\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-7.png\" alt=\"Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando 7\" width=\"236\" height=\"156\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>A partir deste editor de consultas, voc\u00ea deve tocar na aba \u2018<strong>Transformar\u2019<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1756\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-8.png\" alt=\"Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando 8\" width=\"301\" height=\"183\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Siga este caminho: <strong>Aba Transformar &gt;&gt;Tabela \u2013&gt; Usar Primeira Linha como Cabe\u00e7alhos \u2013&gt; Usar Cabe\u00e7alhos como Primeira Linha<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1755\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-9.png\" alt=\"Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando 9\" width=\"522\" height=\"273\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-9.png 522w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-9-300x157.png 300w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/p>\n<p style=\"text-align: left;\">A etapa acima \u00e9 garantir que a primeira linha seja tratada como os dados e a transposta.<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Aperte o\u00a0bot\u00e3o\u00a0<strong>Transpose\u00a0<\/strong>, isso come\u00e7ar\u00e1 a transpor seus dados.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1754\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-10.png\" alt=\"Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando 10\" width=\"623\" height=\"295\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-10.png 623w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-10-300x142.png 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Escolha a op\u00e7\u00e3o \u201c<strong>Usar primeira linha como cabe\u00e7alho<\/strong>\u201d. Isso far\u00e1 com que sua primeira linha de dados transpostos do Excel seja o cabe\u00e7alho.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1753\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-11.png\" alt=\"Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando 11\" width=\"623\" height=\"295\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-11.png 623w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-11-300x142.png 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora toque na guia <strong>Arquivo<\/strong> -&gt; depois clique na op\u00e7\u00e3o <strong>Fechar e Carregar.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1752\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-12.png\" alt=\"Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando 12\" width=\"634\" height=\"348\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-12.png 634w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-12-300x165.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/p>\n<ul>\n<li>Isso fechar\u00e1 a janela do <strong>Editor do Power Query<\/strong>.<\/li>\n<li>Crie uma nova planilha Excel na qual voc\u00ea manter\u00e1 os dados transpostos.<\/li>\n<\/ul>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000;\"><strong>Nota<\/strong><\/span>: fa\u00e7a edi\u00e7\u00f5es apenas na tabela original\/fonte. \u00c0 medida que quaisquer altera\u00e7\u00f5es s\u00e3o feitas na 2\u00aa tabela, ou seja, a tabela de dados transposta ser\u00e1 substitu\u00edda pelos dados da tabela original sempre que for atualizada.<\/p>\n<\/div><\/div>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Leia tamb\u00e9m<\/span>: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/usar-excel-iserror-funcao\" target=\"_blank\" rel=\"noopener\">Desbloqueie os segredos do Excel: fun\u00e7\u00e3o ISERROR no Excel revelada para iniciantes<\/a><\/strong><\/p>\n<\/blockquote>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 3: usando o recurso especial Colar para corrigir a transposi\u00e7\u00e3o do Excel que n\u00e3o funciona<\/strong><\/h3>\n<p style=\"text-align: justify;\">Outro m\u00e9todo eficaz que voc\u00ea pode tentar resolver esse problema \u00e9 usar o recurso Colar especial do Excel. Para us\u00e1-lo, siga cuidadosamente as instru\u00e7\u00f5es abaixo:<\/p>\n<ul>\n<li>Abra a planilha Excel com defeito &gt;&gt; <strong>copie seu intervalo de dados<\/strong>.<\/li>\n<li>Em seguida, clique com o bot\u00e3o direito onde deseja TRANSPOSE os dados.<\/li>\n<li>Escolha a op\u00e7\u00e3o \u201c<strong>Colar Especial<\/strong>\u201d entre v\u00e1rias op\u00e7\u00f5es.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4823 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/7.png\" alt=\"corrigir a transposi\u00e7\u00e3o do Excel que n\u00e3o funciona\" width=\"604\" height=\"407\" \/><\/p>\n<ul>\n<li>Agora, marque a caixa de sele\u00e7\u00e3o \u201c<strong>TRANSPOSE<\/strong>\u201d &gt;&gt; clique em \u201c<strong>OK<\/strong>\u201d.<\/li>\n<li>Reinicie o documento Excel para verificar o problema.<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 4: atualizando a tabela e a consulta<\/strong><\/h3>\n<p style=\"text-align: justify;\">Talvez o <strong>Excel Transpose n\u00e3o funcione<\/strong> porque os dados transpostos contidos na consulta ou tabela n\u00e3o foram atualizados corretamente.<\/p>\n<p style=\"text-align: justify;\">Bem, existem algumas op\u00e7\u00f5es f\u00e1ceis dispon\u00edveis para atualizar os dados da tabela transposta ap\u00f3s fazer altera\u00e7\u00f5es na tabela original.<\/p>\n<p style=\"text-align: justify;\">Cada consulta do Excel cont\u00e9m op\u00e7\u00f5es de atualiza\u00e7\u00e3o. Para saber isso clique com o bot\u00e3o direito em <strong>Consulta&gt; propriedades&gt; uso<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1751\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-13.png\" alt=\"Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando 13\" width=\"467\" height=\"300\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-13.png 467w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-13-300x193.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Aqui voc\u00ea ver\u00e1 a seguinte op\u00e7\u00e3o para escolher conforme sua exig\u00eancia:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Atualize a cada\u2026 minutos<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Defina o intervalo de tempo ap\u00f3s o qual os dados da tabela s\u00e3o atualizados automaticamente, mas ainda significa que duas tabelas podem estar fora de sincronia.<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Atualize os dados ao abrir o arquivo:<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">\u00c9 altamente recomend\u00e1vel manter essa op\u00e7\u00e3o LIGADA.<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">Nota<\/span><\/strong>: tenha cuidado se estiver configurando alguma dessas op\u00e7\u00f5es, pois sempre h\u00e1 alguma diferen\u00e7a de hor\u00e1rio entre a tabela original e a atualiza\u00e7\u00e3o de dados da tabela de transposi\u00e7\u00e3o.<\/p>\n<\/div><\/div>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Leia tamb\u00e9m<\/span>: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-trim-funcao-nao-trabalhando\" target=\"_blank\" rel=\"noopener\">Corrigir problema de fun\u00e7\u00e3o TRIM do Excel que n\u00e3o funciona<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Perguntas frequentes exclusivas:<\/strong><\/h2>\n<h4 style=\"text-align: left;\"><strong>Existe um limite para TRANSPOSE no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">A transposi\u00e7\u00e3o no Excel tem uma limita\u00e7\u00e3o de 65.536 elementos.<\/p>\n<h4 style=\"text-align: left;\"><strong>Por que o Transpose n\u00e3o funciona em planilhas?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Muito provavelmente o Transpose n\u00e3o funciona em planilhas devido a c\u00e9lulas mescladas e linhas e colunas ocultas.<\/p>\n<h4 style=\"text-align: left;\"><strong>Qual \u00e9 o atalho para TRANSPOSE no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Ctrl + Alt + V, ent\u00e3o E \u00e9 o atalho para transposi\u00e7\u00e3o no Excel.<\/p>\n<h4 style=\"text-align: left;\"><strong>Existe uma f\u00f3rmula para TRANSPOSE?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Sim, =TRANSPOSE(A1:F5) \u00e9 uma f\u00f3rmula para a fun\u00e7\u00e3o TRANSPOSE no Excel.<\/p>\n<h4 style=\"text-align: left;\"><strong>Como colar valores e TRANSPOSE no Planilhas Google?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Para colar valores e TRANSPOSE nas planilhas do Google, navegue at\u00e9 Editar &gt;&gt; Colar op\u00e7\u00e3o especial &gt;&gt; Colar comando transposto.<\/p>\n<h2 style=\"text-align: left;\"><strong>Empacotando<\/strong><\/h2>\n<p style=\"text-align: justify;\">Ao compreender as causas comuns de o <strong>TRANSPOSE n\u00e3o funcionar no Excel <\/strong>e seguir as solu\u00e7\u00f5es mencionadas neste blog, voc\u00ea pode garantir que suas tarefas do Excel ocorram sem problemas. Agora, v\u00e1 em frente e aplique essas t\u00e9cnicas para aproveitar o trabalho com o recurso de transposi\u00e7\u00e3o do Excel sem problemas.<\/p>\n<p style=\"text-align: justify;\">Se ainda assim voc\u00ea estiver tendo mais problemas em seu aplicativo Excel, compartilhe conosco atrav\u00e9s de nossa p\u00e1gina no <a href=\"https:\/\/www.facebook.com\/MS-Excel-Repair-Tool-1569953153234271\" target=\"_blank\" rel=\"noopener\"><strong>Facebook<\/strong><\/a>\u00a0&amp;\u00a0<a href=\"https:\/\/twitter.com\/repairmsexcel\" target=\"_blank\" rel=\"noopener\"><strong>Twitter<\/strong><\/a>.<\/p>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Voc\u00ea j\u00e1 tentou usar a fun\u00e7\u00e3o TRANSPOSE no Microsoft Excel e descobriu que ela n\u00e3o funciona conforme o esperado? Pode &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel#more-1747\" aria-label=\"Read more about Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":1765,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[694],"tags":[1508,1509],"class_list":["post-1747","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-erros","tag-excel-transpose-nao-funciona","tag-funcao-de-transpose-do-excel-nao-funciona","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!<\/title>\n<meta name=\"description\" content=\"A Transpose do Excel n\u00e3o est\u00e1 funcionando? Corrija-o agora com nosso guia f\u00e1cil de seguir para resolver o problema de fun\u00e7\u00e3o de Transpose do Excel que n\u00e3o funciona.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!\" \/>\n<meta property=\"og:description\" content=\"A Transpose do Excel n\u00e3o est\u00e1 funcionando? Corrija-o agora com nosso guia f\u00e1cil de seguir para resolver o problema de fun\u00e7\u00e3o de Transpose do Excel que n\u00e3o funciona.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-15T09:46:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-15T13:36:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-pt.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!\",\"datePublished\":\"2024-07-15T09:46:43+00:00\",\"dateModified\":\"2024-07-15T13:36:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel\"},\"wordCount\":1550,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/transpose-function-not-working-in-excel-pt.jpg\",\"keywords\":[\"Excel TRANSPOSE n\u00e3o funciona\",\"fun\u00e7\u00e3o de Transpose do Excel n\u00e3o funciona\"],\"articleSection\":[\"Excel erros\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel\",\"name\":\"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/transpose-function-not-working-in-excel-pt.jpg\",\"datePublished\":\"2024-07-15T09:46:43+00:00\",\"dateModified\":\"2024-07-15T13:36:48+00:00\",\"description\":\"A Transpose do Excel n\u00e3o est\u00e1 funcionando? Corrija-o agora com nosso guia f\u00e1cil de seguir para resolver o problema de fun\u00e7\u00e3o de Transpose do Excel que n\u00e3o funciona.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/transpose-function-not-working-in-excel-pt.jpg\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/transpose-function-not-working-in-excel-pt.jpg\",\"width\":960,\"height\":540,\"caption\":\"Como corrigir Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando Problema\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/transpor-funcao-nao-trabalhando-no-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!","description":"A Transpose do Excel n\u00e3o est\u00e1 funcionando? Corrija-o agora com nosso guia f\u00e1cil de seguir para resolver o problema de fun\u00e7\u00e3o de Transpose do Excel que n\u00e3o funciona.","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:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!","og_description":"A Transpose do Excel n\u00e3o est\u00e1 funcionando? Corrija-o agora com nosso guia f\u00e1cil de seguir para resolver o problema de fun\u00e7\u00e3o de Transpose do Excel que n\u00e3o funciona.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2024-07-15T09:46:43+00:00","article_modified_time":"2024-07-15T13:36:48+00:00","og_image":[{"width":960,"height":540,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-pt.jpg","type":"image\/jpeg"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!","datePublished":"2024-07-15T09:46:43+00:00","dateModified":"2024-07-15T13:36:48+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel"},"wordCount":1550,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-pt.jpg","keywords":["Excel TRANSPOSE n\u00e3o funciona","fun\u00e7\u00e3o de Transpose do Excel n\u00e3o funciona"],"articleSection":["Excel erros"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel","url":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel","name":"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-pt.jpg","datePublished":"2024-07-15T09:46:43+00:00","dateModified":"2024-07-15T13:36:48+00:00","description":"A Transpose do Excel n\u00e3o est\u00e1 funcionando? Corrija-o agora com nosso guia f\u00e1cil de seguir para resolver o problema de fun\u00e7\u00e3o de Transpose do Excel que n\u00e3o funciona.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-pt.jpg","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/06\/transpose-function-not-working-in-excel-pt.jpg","width":960,"height":540,"caption":"Como corrigir Excel Transpor Fun\u00e7\u00e3o N\u00e3o Trabalhando Problema"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Microsoft Excel Transpose n\u00e3o funciona? Corrija agora!"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=1747"}],"version-history":[{"count":7,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1747\/revisions"}],"predecessor-version":[{"id":4824,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1747\/revisions\/4824"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/1765"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=1747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=1747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=1747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}