Merging data from 2 data excel sheets

J

Joe

Hi,

I have two excel workbooks. Both of them contain about 5000 rows and have
identical columns. I need to merge these 2 excel sheets into one.
Unfortunately Shared Workbook option wasn't used. Is there any way I can
merge the data from these 2 excel sheets.

Thanks,

Joe Green
 
J

Joe

May be I didn't explain my problem well. Say student ID, SAT scores GMAT
scorres are 3 columns in both the files. Data in Student ID column in both
the files is same. Here is how the files look like

File 1
Student ID SATScores GMAT Scores
Tom 500
Berry 300
Matt 100

File 2
Student ID SATScores GMAT Scores
Tom 200
Berry 300
Matt 100 700

There are about 5000 rows like this in both the files. I want to combine
these two files so that what I will get is following:

Merged File
Student ID SATScores GMAT Scores
Tom 500 200
Berry 300
Matt 100 700

Hope this explains my problem more clearly.

Joe Green



:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top