Formula for using results from one chart to organize data in second chart?

[ebt]

Hello all,

I'm trying to create a fantasy baseball draft worksheet and am having
trouble with what probably (I'm hoping) would only require a basic
formula. As I draft players in one chart I will be entering their
names and info regarding their eligible positions:

Name 1st Position 2nd Pos. 3rd. Pos.
Smith OF 3B 1B
Jones 1B
Thomas 2B SS
Jackson OF
Davis C
Durham 1B OF


This list will ultimately total 28 players.

In the second chart, I would like to sort the player names by their
eligible positions, and for this chart to fill in automatically as the
draft continues. This chart would have a column for each position:

C
Davis

1B
Smith
Jones
Durham

2B
Thomas

SS
Thomas

3B
Smith

OF
Smith
Jackson
Durham


This chart will have a few more columns for other positions as well.
I'd also like to have both charts side by side on the same page if that
is possible. I'm guessing a pretty basic formula would allow me to do
this but I have no idea what that would be.

Thanks so much for any and all assistance.