Srini’s Tech Tip: Transposing Data in Excel

There are times when you have a data set where the columns and rows need to be switched around for convenience or a better layout, also known as Transposing the Data. Transposing data grants you a better perspective, often leading to greater insight. Handling the data in this way provides the necessary tools for a full analysis.  

Another common circumstance in Excel is that you have too many columns and not enough rows (a wide table), which makes it harder to navigate in the worksheet and to print.  

 

 

 

 

1 Comment

  1. Donna M. Boyd

    This is so helpful! Thank you. One of those things that is always coming up and stopping me in my tracks.

Leave a Reply

Your email address will not be published. Required fields are marked *