Best Microsoft Excel Bloggers

Monday, February 7, 2011

Flipping Your Data

Flipping Your Data

How often have you typed your data in and then wished that it was presented differently?  The good news is that it is extremely easy to flip or transpose your data.

In the spreadsheet to the left, I have sales for each salesperson by month which is pretty standard way to set up your data.  But, I wonder if the data might be more useful if it was presented by month for each salesperson. Rather than retyping or dragging everything around, you can use the Paste Special command and transpose all the data at once.

Here is how to do it.

  • Select the data. In this case A3.G12
  • Copy the data
  • On the Home Tab
  • Click on a cell where you want the new data to begin displaying (upper left cell of the data)
  • Click the dropdown arrow under Paste
  • Select Paste Special
  • Click Transpose
  • Click OK

Voila- Your data is flipped!

No comments:

Post a Comment

Ms. Excel- Resident Excel Geek