We have student test data that is extracted from the student information
system tables into Access and/or Excel. The problem with the data is that
there are too many rows for each student. We only need one row of data.
Example as data is now:

Column A Column B Column C Column D Column E
Student_ID Student_Name Grading_PD Course_# Grade
0001 Sam Smith 1 45.945837 85
0001 Sam Smith 1 23.488945 89
0001 Sam Smith 1 47.893432 75
0001 Sam Smith 2 27.945734 93

We need - one row for the student name with all data in columns.

Column A Column B Column C Column D Column E Column F Column
G
Student_ID Student_Name Gr_PD Course# Grade Gr_PD
Course#
0001 Sam Smith 1 45.945837 85 1
47.893432 75