September 11, 2013

Excel Tricks: Transposing Data

This video highlights the simplicity to reorganize your data with the paste special and transpose feature in Excel.

When do you use this technique?

  • Your data doesn’t appear to be organized logically
  • To make data easier to read
  • To change data from rows to columns
  • If you are to generate a graph with the data and realize the X and Y axis should be switched

The process is simple:

  1. Highlight the desired data to transpose.
  2. Right-click and copy data
  3. Right click on a new cell below the data already listed where you wish to have the transposed data located
  4. Hover cursor over paste special
  5. Select transpose from the dropdown menu

And voila! The data is now transposed and ready for you to do with it as you wish.

 

Check out Technology Advice’s Youtube channel and subscribe for more Excel tricks and future videos to come!

 
Subscribe to our Youtube Channel for more tutorials.

 

Looking for software? Try our Product Selection Tool