Hi Bill, this is called "transposing" data.
Maybe this page will help you out: http://www.tech-recipes.com/rx/2196/openoffice_calc_transpose_table/ Good luck, Jurgen. >----- Oorspronkelijk bericht ----- >Van : bill [mailto:[email protected]] >Verzonden : zaterdag , maart 21, 2009 12:21 PM >Aan : [email protected] >Onderwerp : [users] moving col to row > >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 ? > >-- >Bill Drescher >william {at} TechServSys {dot} com > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
