How Do I reverse axis in a spreadsheet

I have a fairly large (6MB) and mature spreadsheet that I need to have the
columns and rows reversed? (ie. names in the left column and measurements in
the top row) Is there a global function or is this one large pivot table?
--
Thank you,
Chris H