A third criteria would be required to make the distinctions between names. An ID # for each individual would be ideal but barring that the more criteria you have for identification, the better off you are. If there was an Initial or second name, that would also help.
The answer given solves the problem as stated. If there are other complications, they should have been stated in the original problem.
Having said that. To bring in the surname first enter this in F2 and copy down:
Enter this in E2 and copy down to get the given names:
Bookmarks