How do I invert an Excel table (collumns become rows)?

[songstarter]

I am in Excel and need to invert a table so that the collumns will be the
rows and the rows will be the collumns. What is the easiest way to do this?

Thanks!

 

[ryguy7272]

Try this function:
=OFFSET($A$1,ROW(A1)+COLUMN(A1)-2,)


Or, simply copy and paste special > Values > Transpose


Regards,
Ryan--