Reformatting a data table

[Jim Linnenburger]

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!

 

[ruralguy via AccessMonster.com]

You do understand that the data is being presented to you in a normalized
state and you are asking to denormalize it, right?

 

[Jim Linnenburger]

yes, once I am able to merge the two sources, I will export into my
statistical software to generate data reports. The software I use takes each
row as a new entry, so I would need all the different information from 1 ID
number to be in the same row.

 

[pietlinden]

yes, once I am able to merge the two sources, I will export into my
statistical software to generate data reports. The software I use takes each
row as a new entry, so I would need all the different information from 1 ID
number to be in the same row.

use fConcatChild from Access Web. www.mvps.org/access. It's in the
modules section.

 

[Klatuu]

Leave your data as it is and use a Query to export your data.