I'm not sure if this is what you want.

Select all the cells (including the headers)
Data - Pivot Table - Finish

Student Name in "Drop Row Fields Here"
Course # in "Drop Column Fields Here"
Grading Period to the RIGHT of "Course #"
Grade in "Drop Data items here"

You may need to change "Count of Grade" to "Sum of Grade" or something.
DOuble click on the name to change.

HTH,
Barb Reinhardt
"lmcmillan" wrote:

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