STUDENT CLASS SCORE
TOM A 6
TOM B 9
TOM C 3
JUDY A 0
JUDY B 4
FRANCIS A 6
FRANCIS B 6
FRANCIS C 8
FRANCIS D 6
I have the above data in Excel
and wish to reshape to get this
STUDENT A B C D
TOM 6 9 3
JUDY 0 4
FRANCIS 6 6 8 6
I try to copy and transpose but get this
STUDENT TOM TOM TOM JUDY JUDY FRANCIS FRANCIS FRANCIS FRANCIS
CLASS A B C A B A B C D
SCORE 6 9 3 0 4 6 6 8 6
>Solution :
I put your data into a pivot table and was able to format it the way you are looking for. If you didn’t want it in a pivot table you can copy and paste it as text elsewhere.
I put Class as the column field, Student as rows, and then Score as Values and changed it to a sum.
Hope this helps!
