I'm working with Excel 2000 on a Win10 computer.



I have a table that is 25 columns wide and 12 rows high. The table is too wide to be practical. I would like to transpose the columns and rows so that the table is 25 columns high and 12 rows wide. I've tried the "Transpose" forumla but I don't understand it and it doesn't transpose the rows with the columns.

Most of the values in the table are the result of forumlas.

How do I go about transposing the table without messing with the formulas?


(And how do I edit a thread's title? The title of this thread should read "Transposing Columns and Rows in Excel 2000".)