How to interchange a column and row in a table (Transpose) in iWork Numbers?

Question

I want to transpose a table (interchange rows to columns and vice versa). How to do that in iWork Numbers.

Answer 1

The only way to do this seems to be via the INDEX and TRANSPOSE functions. See: http://discussions.apple.com/thread.jspa?messageID=8799221