Home |
Search |
Today's Posts |
#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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to have rows labled A->Z and columns 0->n ? | Excel Discussion (Misc queries) | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Can I split my worksheet and have different size columns and rows. | Excel Discussion (Misc queries) | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) |