Excel/Calc/Whatever: Flip my axes - ie reflect my table across the diagonal

Question

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

Before:

         A       B      C
RED      1       2      3
BLUE     4       5      6

Becomes:

         RED     BLUE
A        1       4
B        2       5
C        3       6

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

Answer 1

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.  

Answer 2

Copy > Paste Special > Check/Select "Transpose"