Hi, I have two excel files, one has ~2100 rows of data the other has ~3500. The two files have two common columns, one is the year and the other is a unique identification number. I need to combine the data from the file with 2100 records with records from the second file and I need to match them based on their unique identification number and year. The catch is, not all of the data on the 3500 record file is obviously going to go onto the 2100 record file and not all of the data in the 2100 record file has an analog in the 3500 record file. I am hoping there is a way to do this easily as I have already spent 2 days to match 350 records and I'm hoping this isn't going to take me another 10 days to finish! Any help or suggestions would be great!
Bookmarks