Swapping columns and rows in table in Excel Sheet

[Excel Sheet]

I have a very large table created in an Excel sheet. I need to apply a
statistical formula, requiring that the coulms and rows must be swapped.
I know that it can be done easily, but I have forgotten how. Can anyone help?
Klavs Dahl Christensen

 

[Bernard Liengme]

Have a look at Paste Special / transpose
best wishes