Hello,
I am trying to use Excel to complete a task.
I have a spreadsheet. In Sheet 1, I have a list of student test results from a reading test. The data is laid out with Student ID#s in Column A and each student's corresponding test scores in Column B through Column E.
In Sheet 2, I have a list of results from a math test. Not all of the students from Sheet 1 took this test, but some of them did. It is laid out in the same way with Student ID#s in Column A and each student's corresponding test scores in Column B through Column E.
What I would like to do is to combine the data into a master sheet, so that I will have Student IDs in Column A, results from Sheet 1(reading) test in Column B - Column E, and results from the Sheet 2 (math) test in Column F - Column I. Since not all students took both tests, I would like the results columns to be blank if they did not take one test or the other.
Is this possible within Excel? I have attached sample data so that you very smart people might better understand what I want. I appreciate any thoughts or hints you can give me. If this is more appropriate to a database program like Access, let me know.
Regards,
Eric
Bookmarks