Copy column / paste row

Posted by Mr. B on September 14, 2001 12:07 PM

Hey everybody. I need to take a 916 rows of data in a single column and turn it into headers of 916 columns...
Any suggestions?

Posted by JAF on September 14, 2001 12:50 PM

Excel has a maximum of 256 columns (A:IV) so there's no way you can have 916 column headings.

If you can get away with 256 or less, then copy your data, select Paste special and tick the transpose box

JAF