Compare and Merge Data from Multiple Sheets in a worksheet

**joeexcell** · 03-06-2012, 12:50 AM

I have looked everywhere, but I can't seem to find something that will work for me. I am a newbie when it comes to programming in excel, but I have been given the task at work to put a database together.

We have a database together already, and I combined the lists into something we could sort alphabetically. Basically, we have a bunch of sheets from each of my colleges with information about students. Some of us have the same students, so that information pops up multiple times in the combined list.

I want to know if there is a way to combine that information, without adding or changing it in anyway. I just simply want to merge it. So, for example:

StudentName ID Period Teacher Math English
Appleseed, Johnny 931 1 Swiss 3 (blank)

combined with this:

StudentName ID Period Teacher Math English
Appleseed, Johnny 931 3 Cheese (blank) 2

To get something like this:
StudentName ID Period Teacher Math English
Appleseed, Johnny 931 1, 3 Swiss, Cheese 3 2

Is this possible in Excel? I have more categories, but this example shows the basics.

Thank you to anyone that can help!

**arlu1201** · 03-06-2012, 05:18 AM

Sure, it can be done. Why dont you attach a sample excel file?

**joeexcell** · 03-06-2012, 08:49 PM

This is a basic example of what we currently have.

Sample File.xlsx

**arlu1201** · 03-07-2012, 01:58 AM

Can you provide an output sheet that you need? Which tab in your attachment should be used as the raw data?

**joeexcell** · 03-07-2012, 09:08 PM

The alphabetical sheet currently shows all the names, even in multiple. I would like it to combine the multiples and only show each student one time with the information combined. The raw data is the names from each teacher in those tabs. Then, I have it set up to pull that info. on to the "By teacher" and "Alphabetical" sheets. Does that make sense?