Excel, Excel 2003, Excel 2007, Excel 2010, MS Office, Programming, Software, Tool

Pivot a Row or Column of Data in Excel

Excel is a great tool for data manipulation. One feature that can come in handy is the ability to pivot a data row into a column or pivot data in a column of information into a row.

It’s actually quite easy to do data pivots in Excel. Pivoting into the horizontal or vertical form that you need is just a few clicks away.

I’ve been doing pivots primarily in Office 2007, but the principals should stay the same in more modern versions of Excel.

Here, step-by-step, is how to pivot your data:

  1. In your Excel Worksheet select either the row or column of text you want to pivot
  2. Use the Ctrl-C key combination to copy the data
  3. Now click on the starting cell where you want to pivot your data to
  4. Right-Click the starting cell to show the Options window
  5. Select the option to Paste Special
  6. In the Paste Special popup window click the Transpose checkbox at the bottom right
  7. Click the OK button: Your data will now appear pivoted

I hope this tip has been useful to you. Please leave a comment below if you have other handy Excel tips to share.

1 thought on “Pivot a Row or Column of Data in Excel”

  1. What if you want to use the same starting cell?
    When you try to Paste starting in the same cell, it says “This selection isn’t valid. Make sure the copy and paste areas don’t overlap unless they are the same size and shape.”
    I tried using Cmd-X to Cut rather than Copy before pasting, but it doesn’t even let you Paste Special at all in that case.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s