Hi all,
I hope this is a simple enough request... but it's driving me batty!
I'm working with a large extract of student grade school data, and I've got 3 columns in question...
StudentID, TeacherName, CourseCode
For a given StudentID, the data I'm working with has each CourseCode duplicated 4 times. I'm wanting to have it only show a given CourseCode once, in a single row... not four rows.
So, right now it looks like this:
A1 B1 C1
StudentID TeacherName CourseCode
123 Jones RDG1
123 Jones RDG1
123 Jones RDG1
123 Jones RDG1
Any ideas how to get this to just give me one row for each student ID, instead of four? Since multiple StudentID's can take the same courses, I need to it hide duplicates based on each student's ID number. Hope this made sense. Thanks for any help!
-Ryan
I hope this is a simple enough request... but it's driving me batty!
I'm working with a large extract of student grade school data, and I've got 3 columns in question...
StudentID, TeacherName, CourseCode
For a given StudentID, the data I'm working with has each CourseCode duplicated 4 times. I'm wanting to have it only show a given CourseCode once, in a single row... not four rows.
So, right now it looks like this:
A1 B1 C1
StudentID TeacherName CourseCode
123 Jones RDG1
123 Jones RDG1
123 Jones RDG1
123 Jones RDG1
Any ideas how to get this to just give me one row for each student ID, instead of four? Since multiple StudentID's can take the same courses, I need to it hide duplicates based on each student's ID number. Hope this made sense. Thanks for any help!
-Ryan
