1.0Xelplus - Leila Gharanihttps://www.xelplus.comLeila Gharanihttps://www.xelplus.com/author/xelplus/Excel Hack to Change Horizontal Data to Verticalrich600338<blockquote class="wp-embedded-content" data-secret="vV2zv3RKUN"><a href="https://www.xelplus.com/excel-horizontal-data-to-vertical/">Excel Hack to Change Horizontal Data to Vertical</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.xelplus.com/excel-horizontal-data-to-vertical/embed/#?secret=vV2zv3RKUN" width="600" height="338" title="“Excel Hack to Change Horizontal Data to Vertical” — Xelplus - Leila Gharani" data-secret="vV2zv3RKUN" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script>
/*! This file is auto-generated */
!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);
</script>
https://www.xelplus.com/wp-content/uploads/2019/05/Transpose-Horizontal-65a266.png889500Here's an Excel Hack that shows an unusual but simple method to change horizontal data to vertical. The advantage of this hack is it's dynamic so if you add more values to the horizontal data it will reflect in the vertical one.