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
|