Re: Reformatting a data table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 wrote:
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 (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200710/1

.

Relevant Pages

  • Political Expediency or Policy Flexibility?
    ... Political Expediency or Policy Flexibility? ... years after the start of the policy of teaching Science and Math in English, ...
    (soc.culture.malaysia)
  • combining data from different rows into 1 column
    ... that I am given will have data in this format: ... 94911 30304E Math II ... 94911 40405E English II ... 94911 50506E Science II ...
    (microsoft.public.excel.misc)
  • Re: Cross Reference Table Design and Query
    ... I have a cross-reference table which stores student class enrollment ... MARY MATH ... MARY SCIENCE ...
    (comp.databases.oracle.server)
  • Re: "Its only May"
    ... Usually a student is better at math or English. ... Perhaps his area was science. ...
    (alt.sports.baseball.ny-yankees)
  • Re: Are there any non-gifted scientists?!?!?
    ... >I'm a high school student, about to go to college to study math and/or ... More recently I've picked up math as a hobby ... >and become more of a science nerd than a computer nerd. ... I'm not going to become an outstanding student overnight. ...
    (comp.programming)