View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RB[_2_] RB[_2_] is offline
external usenet poster
 
Posts: 15
Default 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!