| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Turn data | Excel Discussion (Misc queries) | |||
| Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Linear Mode
