Searching for players in a particular position

[Steviefiege]

Hi,
I have a list of players & their positions:

[TABLE="width: 277"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Alcock, Craig[/TD]
[TD]Full Back (Right)[/TD]
[/TR]
[TR]
[TD]Alcock, Craig[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Alcock, Craig[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Alcock, Craig[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Anderson, Tom[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Anderson, Tom[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Andrew, Danny[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Baudry, Mathieu[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Baudry, Mathieu[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Beestin, Alfie[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Beestin, Alfie[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]Beestin, Alfie[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Beestin, Alfie[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]Ben Khemis, Issam[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Blair, Matty[/TD]
[TD]Full Back (Right)[/TD]
[/TR]
[TR]
[TD]Boyle, Andy[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Boyle, Andy[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Butler, Andy[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Butler, Andy[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Coppinger, James[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Coppinger, James[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Coppinger, James[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]Evina, Cedric[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Garrett, Tyler[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Houghton, Jordan[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Houghton, Jordan[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Houghton, Jordan[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Kiwomya, Alex[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]Kiwomya, Alex[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Kiwomya, Alex[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]Kiwomya, Alex[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]Kongolo, Rodney[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Kongolo, Rodney[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Kongolo, Rodney[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Kongolo, Rodney[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Lawlor, Ian[/TD]
[TD]Goalkeeper[/TD]
[/TR]
[TR]
[TD]Lund, Mitchell[/TD]
[TD]Full Back (Right)[/TD]
[/TR]
[TR]
[TD]Lund, Mitchell[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Lund, Mitchell[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Mandeville, Liam[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Mandeville, Liam[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]Marosi, Marko[/TD]
[TD]Goalkeeper[/TD]
[/TR]
[TR]
[TD]Marquis, John[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Full Back (Right)[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]May, Alfie[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]May, Alfie[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]May, Alfie[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]McCullough, Luke[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]McCullough, Luke[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]McCullough, Luke[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Rowe, Tommy[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Rowe, Tommy[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Rowe, Tommy[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]Whiteman, Ben[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Whiteman, Ben[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Whiteman, Ben[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Williams, Andrew[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]Williams, Andrew[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]Williams, Andrew[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]Wright, Joe[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Wright, Joe[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Wright, Joe[/TD]
[TD]Full Back (Right)
[/TD]
[/TR]
</tbody>[/TABLE]

How do i for example, make a list of everyone who plays in Central Defender?

Rgs
Steve

 

[Frank_Excel]

Hi Steve,
You can use the filter on the second column or use a pivot table.
KR.
Frank

 

[Steviefiege]

I want it seperate though, for example in another sheet, i'll have my position at the top (Goalkeeper), then underneath that, all the players that can play there. Like in my example below:

Goalkeeper FB (Right)

Lawlor, Ian Alcock, Craig
Marosi, Marko Blair, Matty

etc....