Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .