I have a column of data with names in and an adjacent column with data connected to that name e.g. test score. Some names 9students) appear several times as they have several test scores. There may howevr be two students called Peter Smith so a simple pivot doesn't work as it will combine the different Peter smiths scores. My solution so far is to add a column which contains the students 'Unique Pupil Number' , contaginate this with their name, and run the pivot of the contaginated field. It works but I was wondering if there was a way of running the pivot of the Unique Pupil Number and getting the pivot to show the relevant student name in the next column.

Or any other solution

Thanks