| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you change the rows to columns and columns to rows.
Ok, I am stumped on how to do this? I have a spreadsheed that has Dates in the A column and Data in the 1 row. I want to make is so, the data is in the A column and Dates run accross in the 1 column. How can I do this? Sound easy, but I am stumped???  -- cc4digital ------------------------------------------------------------------------ cc4digital's Profile: http://www.excelforum.com/member.php...o&userid=26569 View this thread: http://www.excelforum.com/showthread...hreadid=398437 |
|
#2
|
|||
|
|||
|
Highlight your data and copy it into the clipboard. Move to an open
spot in the spreadsheet and click Edit Paste Special, then select the Transpose box and click OK. It takes a little getting used to, but should do what you need. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you change rows to columns | Excel Discussion (Misc queries) | |||
| How do I change columns going from left to right to rows going up. | Excel Discussion (Misc queries) | |||
| change data in rows to be viewed in columns | Excel Discussion (Misc queries) | |||
| Change data to appear in rows instead of columns (reverse a table. | Excel Discussion (Misc queries) | |||
| Change rows to columns and vise versa | New Users to Excel | |||
Linear Mode
