Array formula help pease

[scareycarey]

Wonder if someone can help me please

I have a list column A = Team, Column B = Name ID and Column C = Name (in sample "As is")

What I want to do is create another list (in sample below "what I need") but in Team Order so it finds for example Team DA in column A then lists all the Name ID and names in that Team.

I know that I could sort it but the original list is linked to another sheet which automatically updates and I need to put the results h spreadsheet.

AS IS			What I Need
Team ID	Name ID	Name
DA	530	George Baines 14-18			DA	530	George Baines 14-18
DC	820	Ricky Josey 14-18				321	Constantine Simion 06-14
DF	895	Michael Wyatt 14-18				1976	Benjamin Uzzell 06-14
DB	2569	Aaron Wilson 14-18
DJ	3815	Amir Hashemi 14-18
DO	745	Paul Snarey 14-18			DB	2569	Aaron Wilson 14-18
ED	244	John McDonnell 06-14				1959	Jeffery Elliott 06-14
DA	321	Constantine Simion 06-14
DP	685	Rene Andrt 06-14
DX	901	Gary Owen Armstrong 06-14			DC	820	Ricky Josey 14-18
EC	1035	Jolita Raupelyte 06-14				3677	Nurudeen Ali 06-14
DM	1047	Marcin Krzaczynski 06-14				5469	Katarzyna Kisielewska 06-14
DE	1379	Joaquim Monteiro 06-14				99	Curtis King 14-22
DM	1627	Saad Ali 06-14
DZ	1700	Dean Sawyer 06-14			DE	1941	Jonathan Leacock 06-14
DE	1941	Jonathan Leacock 06-14				450	Aydan Ahmedov 14-22
DB	1959	Jeffery Elliott 06-14
DA	1976	Benjamin Uzzell 06-14
DC	3677	Nurudeen Ali 06-14
DF	5178	Terrence Mullin 06-14			DF	895	Michael Wyatt 14-18
DC	5469	Katarzyna Kisielewska 06-14				5178	Terrence Mullin 06-14
DC	99	Curtis King 14-22				523	Bothwell Jones 14-22
DK	304	Dieu Mukoko 14-22				1052	Nathaniel James 14-22
DE	450	Aydan Ahmedov 14-22
DF	523	Bothwell Jones 14-22
DF	1052	Nathaniel James 14-22
DX	4172	Ainars Egle 14-22
EC	4484	Laction Ale 14-22
DM	4291	Ganesh Gurung 14-22
DK	909	Leslie Madondo 14-22

<tbody>
</tbody>

Hope this makes sense

Regards


Scarey

 

[DRSteele]

I think a Pivot Table might make quick work of this.