Glide Training Logo

Using Transpose in Excel to rotate data


Written by Jane Hames

I often hear a ripple of words like “wow”, “ooo, I never knew that”, “ahhh, write that down” when I show my workshop participants how to use the Transpose feature, so I thought I would share it with you too!

Transpose enables you rotate the orientation of data with row and column headings.

So from this:


You get this:


Here’s how

  1. Highlight your data and select Copy.
  2. Click on the starting cell for the transposed data.
  3. Click on the arrow below the Paste button and click on Transpose.
  4. paste-options

Voila! The data is rotated!

previous post: Changing a negative value into a positive value in Excel

next post: The Perfectly Centred Heading In Excel