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!!