Turn data
 

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.

Turn data
 

~Make a backup copy of your data to work from (just in case, so you
don't lose data)
~Highlight the entire range of data; click Edit Copy
~Choose a new location, on a different sheet perhaps; click Edit
Paste Special and select the Transpose box; click OK

Does that do it for you?

Turn data
 

thank you so much. You are a genius.

"Dave O" wrote:

~Make a backup copy of your data to work from (just in case, so you
don't lose data)
~Highlight the entire range of data; click Edit Copy
~Choose a new location, on a different sheet perhaps; click Edit
Paste Special and select the Transpose box; click OK

Does that do it for you?