Excel 2003 - change columns to rows and rows to columns
 

tHi, I have a number of spreadsheets that have come from different divisions.
One of them is different, ie their column headings are where the others
have their row headings, and vice versa. There is data in the table. Is
there an easy way to turn this around wihout affecting the integrity of the
data? I don't know the first thing about code, so would prefer a solution
that does not involve that. Many thanks!