If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can you change rows to columns
I have a large dataset I entered in MS Works Spreadsheet. It turns out I
need to transpose the matrix, ie change the columns to the rows and the rows to the columns. Is this possible. I hope I do not have to reenter all the data. THANKS so much! |
#2
|
|||
|
|||
Haven't used Works in years but in excel, you can copy a table, then
(preferably in a new sheet) paste special and select transpose. Note that there are problems if there are many rows since the number of columns are rather few -- Regards, Peo Sjoblom (No private emails please) "Brent" wrote in message ... I have a large dataset I entered in MS Works Spreadsheet. It turns out I need to transpose the matrix, ie change the columns to the rows and the rows to the columns. Is this possible. I hope I do not have to reenter all the data. THANKS so much! |
#3
|
|||
|
|||
Hi!
This is an Excel forum. Don't know if this will work in Works! Does Works accept array's? Does it have the Transpose function? Does it have Paste SpecialTranspose? Biff "Brent" wrote in message ... I have a large dataset I entered in MS Works Spreadsheet. It turns out I need to transpose the matrix, ie change the columns to the rows and the rows to the columns. Is this possible. I hope I do not have to reenter all the data. THANKS so much! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is it possible to have rows labled A->Z and columns 0->n ? | kevinm | General Discussion | 5 | May 27th, 2005 02:52 AM |
How do I change columns going from left to right to rows going up. | Steve | General Discussion | 2 | April 7th, 2005 05:39 PM |
Printing problems with columns and rows | Ann Shaw | General Discussion | 0 | February 17th, 2005 05:35 PM |
Conditional Hiding of Rows or Columns | sanjay_suda | General Discussion | 6 | June 18th, 2004 04:03 PM |