Can you change rows to columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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)
 
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 Special>Transpose?

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Convert long column to rows 3
How to transpose data (Row to column) without losing the cell link 3
Transpose, but how? 0
Transpose Large Column to Row 2
How to covert rows to columns or columns to rows. 11
Sort / Copy Macro 2
Invert a column of data. 4

Back
Top