Turn Data

[RTimberlake]

Is there a way to turn the data in an Excel spreadsheet so that what is on
the top is now on the side and what is on the side is now on top?
I need to export my spreadsheet into Access but, I can't get it to format
correctly in its current orientation.

 

[RTimberlake]

I figured out the answer, so don't bother responding. Thanks anyway.

 

[Klatuu]

This is an Access News Group. You would probably get a better answer in an
Excel News Group; however, I think the answer to your question is to use
Copy, Paste Special, and check Transpose.