LifeTricks.com 
USER CP
Site Navigation 
UPVOTE
UP
41
DOWN
DOWNVOTE
Excel Spreadsheet - Excel Spreadsheet Trick: Transpose Data from a Row to a Column
UPVOTE
41
DOWNVOTE
  • life tricks short link

Excel Spreadsheet Trick: Transpose Data from a Row to a Column

Excel Spreadsheet

Copy the area you want to transpose, move the pointer to another blank location. Go to Home->Paste->Transpose, please note that this function won’t activate until you copy the data first.

Trick Source:

Is this trick using work of your own without attribution? Click here to PM the user and let them know!

Author Comments

Avatar of Love
amourdange says:

You would use this feature if you want to transpose data to get a better display; however, retyping all data would be the last thing you would need to do if you know how to use the Transpose function in Paste.



User Comments