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.

Advertisements

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 )

Google+ photo

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

Connecting to %s