At 07:21 21/03/2009 -0400, Bill Drescher wrote:
I need to construct a grading spreadsheet. The student's grades are exported as a .csv file with each student's raw scores as a row.(and thus each assignment is a column). Unfortunately I need to copy and paste the possible scores for each assignment from a html copy, where the scores are 1 column. In order to compare the student scores with the possible scores I need to convert the column of possible scores to a row. How ?
o Copy (or Cut) the relevant cells. (You cannot do this with a complete column, as it will be too big.) o Paste the material where you want it to appear, but using Edit | Paste Special... (or right-click | Paste Special... or Ctrl+Shift+V) instead of normal Paste.
o In the Paste Special dialogue, under Options, tick Transpose. I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
