G
Guest
I am trying to merge two different data tables from two different sources.
The difficulty I am having is that one of the sources needs to have the data
table reorganized before I can do the merge. The data table that I need to
reorganize comes to me with multiple records for the same person. It looks
like this:
93900 30303E Math
93900 40404E English
93900 50505E Science
94911 30304E Math II
94911 40405E English II
94911 50506E Science II
the first column is the student ID, the second column is the course number,
the 3rd column is the course description.
I need to find a way to combine the 3 entries for each student ID into 1
single entry that would look something like this:
93900 30303E Math 40404E English 50505E Science
94911 30304E Math II 40405E English II 50506E Science II
Anybody have any ideas on how to accomplish this without doing it manually?
(The prospect of doing that with 3500 students does not seem overly
attractive to me right now.)
Thanks in advance!
The difficulty I am having is that one of the sources needs to have the data
table reorganized before I can do the merge. The data table that I need to
reorganize comes to me with multiple records for the same person. It looks
like this:
93900 30303E Math
93900 40404E English
93900 50505E Science
94911 30304E Math II
94911 40405E English II
94911 50506E Science II
the first column is the student ID, the second column is the course number,
the 3rd column is the course description.
I need to find a way to combine the 3 entries for each student ID into 1
single entry that would look something like this:
93900 30303E Math 40404E English 50505E Science
94911 30304E Math II 40405E English II 50506E Science II
Anybody have any ideas on how to accomplish this without doing it manually?
(The prospect of doing that with 3500 students does not seem overly
attractive to me right now.)
Thanks in advance!