jayploc
10-14-2008, 07:59 AM
Hello,
I have a spreadsheet that is kind of messy despite many "paste special" attempts I tried. The first column lists names but last and first names are in different columns and the grade info in following columns is in a row that consists of the first to rows (last, first), merged. (Sorry that's the best I can describe).
I have attached the workbook (only 1 sheet), and its as cleaned-up as I could get it. If someone could help me I would greatly appreciate it...
I want the rows to be in the format:
STUDENT | Resp | Comp | Task | ...
last, first | 43 | 52 | 32 | ... (one row)
.... etc...
Hopefully I have explained this well enough.
Thanks,
Jay
I have a spreadsheet that is kind of messy despite many "paste special" attempts I tried. The first column lists names but last and first names are in different columns and the grade info in following columns is in a row that consists of the first to rows (last, first), merged. (Sorry that's the best I can describe).
I have attached the workbook (only 1 sheet), and its as cleaned-up as I could get it. If someone could help me I would greatly appreciate it...
I want the rows to be in the format:
STUDENT | Resp | Comp | Task | ...
last, first | 43 | 52 | 32 | ... (one row)
.... etc...
Hopefully I have explained this well enough.
Thanks,
Jay