Home |
Search |
Today's Posts |
#1
|
|||
|
|||
combine two files
Hi All:
I have two files. One looks like: Faculty Course Tom ACC 122 Bill BUS 220 Charles CIS 891 The other one looks like: Course Student Grade ACC 122 Lisa A ACC 122 Nacy B ACC 122 Jim A BUS 220 Sue A BUS 220 Carla B CIS 891 Xu A CIS 891 Ena C CIS 891 Karen D Is there any way I can merge these two files, or actually I want to add faculty name to each student grade record. I know we can merge these two files but the key variable Course is duplicated in the second file. I could not use SPSS to merge them. I don't know Macro. Is there anyone who can help me out? Thanks a lot. Charles |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recently Used File List - 2002 Contains 'Temp' Files | Excel Discussion (Misc queries) | |||
merging my excel files | Excel Discussion (Misc queries) | |||
how to combine multiple files in ms excel | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
Combine multiple Excel files into one master | Excel Discussion (Misc queries) |