{"version":"1.0","provider_name":"Excel Advisor","provider_url":"https:\/\/exceladvisor.org\/es","author_name":"Equipo editorial","author_url":"https:\/\/exceladvisor.org\/es\/author\/sq4n1shex3els\/","title":"\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"RNJFXU7gtE\"><a href=\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/\">\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/exceladvisor.org\/es\/columna-a-fila\/embed\/#?secret=RNJFXU7gtE\" width=\"600\" height=\"338\" title=\"\u00ab\u00bfc\u00f3mo cambiar una columna en una fila (viceversa)?\u00bb \u2014 Excel Advisor\" data-secret=\"RNJFXU7gtE\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/exceladvisor.org\/es\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","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;]","thumbnail_url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-et-dages.png"}