Okay, I'm fairly certain that this is going to be an easy question to answer, but I've tried looking up the answer--and to be fair, I don't know what category to try to find it under.

What I'm doing is this: I'm building a spreadsheet for several little-league softball teams. I am entering each player, his or her age, whether they are a "him" or a "her", and what position they play. I need the Spreadsheet to be fully searchable--or at least "sortable" (if "sortable" is a word).

What I want to be able to do is this: be able to sort the data based on the child's age and what position they play.

The problem I'm having is this: several of the children play multiple positions.

Let's say we have little Billy. Billy plays third baseman, and he's an alternate pitcher. When I sort the data according to position, I'd like the following to happen. If I sort for pitchers, I want Billy's name to come up, but if I sort for Third Basemen, I want his name to come up too. How do I enter two different sets of data into the same column and get excel to attach it to the same player without entering the player into the database twice?