Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you rotate a table of excel data from horizontal to vertic.
I just want to take a table of 2 rows by 100 columns and turn it into a 2
column table. How can I do this? |
#2
|
|||
|
|||
hi,
copy a row. Select a cell where you want to put the column. editpaste specialtranspose.(towards the bottom of the paste special form) the row in now a column. do that with the other row. -----Original Message----- I just want to take a table of 2 rows by 100 columns and turn it into a 2 column table. How can I do this? . |
#3
|
|||
|
|||
Select the whole set of cells (say it's A1:CV2), Edit/Copy it, then select A3,
Edit/Paste Special and select the Transpose option. Now you can delete rows 1:2. On Fri, 11 Feb 2005 10:35:16 -0800, "DavidEllis_97062" wrote: I just want to take a table of 2 rows by 100 columns and turn it into a 2 column table. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
pasting excel data in a powerpoint slide | Excel Discussion (Misc queries) | |||
How do I plot Excel data on a floorplan? | Excel Discussion (Misc queries) | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |