Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Lets say I have a table and I want it flipped across the diagonal. So instead of X by Y its Y by X...


         A       B      C
RED      1       2      3
BLUE     4       5      6


         RED     BLUE
A        1       4
B        2       5
C        3       6

Is there an easy, built-in way to do this?

share|improve this question
up vote 5 down vote accepted

In Microsoft Excel 2007:

  1. Copy (not cut) the data to be "flipped".
  2. Click in the upper left corner of a non-overlapping region where you want the data to be flipped into.  (You might want to do this in a new worksheet.)
  3. Click on the arrow (triangle) below the Paste icon.
  4. Click on Transpose.   Screen shot of Microsoft Excel 2007 Paste menu.
share|improve this answer

Copy > Paste Special > Check/Select "Transpose"

share|improve this answer
I know this works in excel. Does it work in the others as well? – soandos Aug 31 '12 at 20:54
I don't have either set up, so I'm not sure. I know this feature is NOT available in Google Docs though. – Toneloc427 Aug 31 '12 at 21:06
This is correct for LibreOffice Calc. – DaleSwanson Sep 1 '12 at 9:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.