Turn Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top