Transpose (rotate) data from rows to columns or vice versa

If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you rotate the data from columns to rows, or vice versa.

For example, if your data looks like this, with sales regions listed along the top and quarters along the left side:

Regional data in columns

You can rotate the columns and rows to show quarters along the top and regions along the side, like this:

Regional data in rows

Here’s how:

  1. Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C.

    Note    Make sure you copy the data to do this. Using the Cut command or Ctrl+X won’t work.

  2. Right-click the first cell where you want to paste the data, and pick Transpose Tranpose button image.

    Pick a spot in the worksheet that has enough room to paste your data. The data you copied will overwrite any data that’s already there.

    Paste Options menu

  3. After rotating the data successfully, you can delete the original data.

Tips for transposing your data

Applies To: Excel 2013



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language