I have a document that looks like this?


Table of students who have chosen physics as a primary choice 1.

ID Primary Choice Secondary Choice Programs
515 1 2 math
3 english
6 spanish


I am trying to create a pivot table that breaks out the primary choice
(first column), them the primary choice(second column) and then progrm
name - the count will be on student ID.

As it is, I first have to fill down the records so that I end up with
this:
ID Primary Choice Secondary Choice Programs
515 1 2 math
515 1 3 english
515 1 6 spanish

Then create the pivot table.

The file has about 10000 student IDs and this is very time consuming,
is there a better way to do this?

Thanks