break it up into blocks of 200 columns, and edit copy edit paste special
transpose each one in turn. This will work if no column is more than 250
rows deep. If that is the case, you will need to make multiple sheets.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=572984