I would use a help sheet, select the table, copy it, select the first cell
where you want it on the help sheet,
do editpaste special and select transpose. Obvisouly if you do it the other
way you have to
bear in mind that you can only transpose 256 rows due to the max number of
columns

--

Regards,

Peo Sjoblom


"Motheroftwoboys" wrote in
message ...
I have a fairly large table in which I need to switch the columns to the
rows. Is this possible to do?