Hi!

I have a large sum och data in the order below:

Choice Course 1 Course 2 Course 3 Course 4
1 Name 1 Name 3 Name 2 Name 1
2 Name 3 Name 4 Name 4 Name 3
3 Name 5

I would like to structure it differently to the format below:

Choice 1 2 3
Name 1 Course 1 Course 4
Name 2 Course 3
Name 3 Course 1 Course 2 Course 4
Name 4 Course 2 Course 3
Name 5 Course 1

Is this possible? I have been trying to use pivottables without any luck.

Cheers and thanks,
Pete