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!