Brian Barker wrote:
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.)
my column only has about 40 rows.
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.
as usual, that helps.
Thanks
--
Bill Drescher
william {at} TechServSys {dot} com
