Have a look at Paste Special / transpose
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Excel Sheet" <Excel wrote in message
...
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