I'm trying to show that everyone is somehow connected at my school.

(Jimmy is friends with Timmy. Timmy is brother to Janie. Janie played soccer with Billy.)

That kind of thing, except on a large scale.

I have all the data, but it's all out of order so no one can make out the connections. My problem is that I want to have excel automatically match up all the connections. I am somewhat experienced with excel, but am new to databases. I don't even know if that's what I should be using.

Does anyone know how I can solve this problem?

Even automatically pairing names would be great.

Any help or ideas would be appreciated! Thanks!!