Depth Chart

[Madcat]

G'day all,

I'm hoping some can help me out regarding a depth chart for my sporting organisation.

At the moment I have a roster with all player information on it:

What I am hoping to achieve on a separate page is the following:
FB: Josh Dugan / Jordan Rankin / Evander Cummins / Omar Slaimankhel
WI: Joseph Leilua / Dale Copley
CE: Kyle Stanley / Tim Lafai / Konrad Hurrell
FE: Ben Hunt / Carlos Tuimavave
HB:
PR: Ryan James
HK: Nathan Fien / Kurt Baptiste / Cameron King
SR: Sam Thaiday / Tyronne Peachey
LK: Nate Myles / Reni Maitua / Matt Prior

Thanks so much in advance for taking the time in helping me out.

Cheers
Madcat

 

[Madcat]

G'day all,

I'm hoping some can help me out regarding a depth chart for my sporting organisation.

At the moment I have a roster with all player information on it:

What I am hoping to achieve on a separate page is the following:
FB: Josh Dugan / Jordan Rankin / Evander Cummins / Omar Slaimankhel
WI: Joseph Leilua / Dale Copley
CE: Kyle Stanley / Tim Lafai / Konrad Hurrell
FE: Ben Hunt / Carlos Tuimavave
HB:
PR: Ryan James
HK: Nathan Fien / Kurt Baptiste / Cameron King
SR: Sam Thaiday / Tyronne Peachey
LK: Nate Myles / Reni Maitua / Matt Prior

Thanks so much in advance for taking the time in helping me out.

Cheers
Madcat

Any help would be terrific!

 

[mvptomlinson]

Please edit your second post to remove the quotation of your entire first post. Secondly, it hasn't even been an hour since you initially posted your question. Have some patience. I'm pretty sure everyone here volunteers their time and knowledge, so they help when they can.

 

[teylyn]

FYI, cross-posted at http://www.excelforum.com/excel-general/811160-depth-chart-formula-question.html