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

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

Barb,

I was tinking and had it close, but you know that only counts in horseshoes
and hand grenades.... ;-) I have a stupid question on Friday afternoon. It
looks great except that where my grades are suppose to be it's the count of
grade and I changed it to sum and everything else in that list and the actual
grades never show. Any suggestions? My brain hurts. Your help so far has
been an enormous time saver for our teachers. Thanks! Lynn


"Barb Reinhardt" wrote:

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