Transpose Cell Contents
I have data in this format about the subjects that students take
Student A Student B Student C Student D
Math Yes No Yes No
Science No No Yes Yes
Arts Yes Yes No No
English Literature No Yes Yes Yes
I want the data to be represented in this fashion:
Student A Math
Arts
Student B Arts
English Literature
.........
Any suggestions on this?
Thanks!
|