Ubuntu
openoffice.org package

how to concert coloum values into matrix in excel

Asked by Gaurav

 i have to column of field numbers and a third column of matching score between the other two's.....now i want to arrange the two column as a row and column for and put the third column values?(matching score) accordingly into the right cell.

I'm not getting any clue hoe to go for this.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
David Hoeffer (d-hoeffer) said : 		#1

I'm assuming that you're using OpenOffice.org Calc. The function for transforming rows to columns is called "transpose". To use it, select your columns, choose, "Edit->Cut" from the menu, and then "Edit->Paste special" where you want to insert it. In the section called Options, choose Transpose.

Can you help with this problem?

Provide an answer of your own, or ask Gaurav for more information if necessary.

To post a message you must log in.