Pivot required that sums data for names, where names are not unique

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

Good point. Because I'm fussy. I want UPN and name on same line for presentation purposes. A colleague has suggested I use a lookup table to put the names after the pivot table that uses the UPN and Name columns as the basis for the lookup. Not sure how this works but will try.