One way is to copy and paste special with transpose as an option but that's
a 'manual" option.. What are the errors you are seeing with TRANSPOSE?

"horosho" wrote in message
...
Hi, I know this is fairly basic, but I have a huge data set that is a
bunch
of survey questions that have all been entered in. However, all the
information that I want in rows is currently in columns and vice versa.

I tried to use the TRANSPOSE function to fix this with no luck. i'm sure
there is an easy way to fix this, so if you know it, please tell me! thank
you.