View Single Post
  #1   Report Post  
Charles
 
Posts: n/a
Default Merger Two Data Sheet

Hi All:

I need to merge two variables but I could not find any instructions on this
issue.

I have a data sheet 1 like this:

Course Hours
Acc100 3.0
Acc122 3.0
Mar095 3.5
Bus100 4.0
Bus101 3.0

I have data sheet 2 like:

Course Instructor
Acc100 Charles
Acc101 David
Acc122 James
Mar095 Mary
Mar100 Greg
Mar155 Sharon
Bus100 Lisa
Bus101 Sue
Bus105 Tom


Data sheet 1 and data sheet 2 have the same variable Course. Course contains
much more records in data sheet 2 and all records of Course in data sheet 1
are included in Course in data sheet 2. Now I want to merge these two sheets
to create file like:

Course Instructor Hours
Acc100 Charles 3.0
Acc122 James 3.0
Mar095 Mary 3.5
Bus100 Lisa 4.0
Bus101 Sue 3.0


Is there is anyone who could tell me the procefures I can accomplish this
goal? Any suggestions and advices are greatly appreciated.

Charles