Occasionally I receive an Access Database file containing the names of approximate 1000 students. The fields are: Student Name, Student ID Number, Date of Birth, Exam Score 1, Exam Score 2, Exam Score 3.
For some reason that is not in my control, instead of all the exam scores being listed in the same record, each student with more than one exam score gets multiple records.
The first record includes data under Student Name, Student ID Number, Date of Birth, and Exam Score 1 but nothing under Exam Score 2 and 3.
The second record includes the same data under Student Name, Student ID Number, and Date of Birth. Exam Score 2 is populated, but Exam Score 1 and 3 are blank.
The third record includes the same data under Student Name, Student ID Number, and Date of Birth. Exam Score 3 is populated, but Exam Score 1 and 2 are blank.
Is it possible to combine the multiple records of each student to produce one record with the three exam scores without doing it manually?
Thank you for reading thus far and for your time.