How to write a script to allocate data

[katekaew]

I have to allocate the students' timetable. I already have a Table containing Student_id, Subject_code and Building_no. This table has all the possibility of Building_no for each student. For example,
Student_id Subject_code Building_no
101 A 5
101 A 3
101 B 3
101 B 5
101 B 1
101 C 5
101 C 2
101 C 1
101 D 3
101 D 1

The result will be:
Student_id Subject_code Building_no
101 A 5
101 B 1
101 C 2
101 D 3

How to write the VBA script or Use Access to get this result?
Thank you very much!

 

[Mile-O]

And what logic determines this result?