Hi,

Assume your data in A1:C16 row 1 being the header

Type the Agency name in G1

In G2 and copied down and across,

=IFERROR(INDEX(B$2:B$16,SMALL(IF($A$2:$A$16=$G$1,R OW(B$2:B$16)-ROW(B$2)+1),ROWS(G$2:G2))),"")

It's an array formula. Confirmed with CTRL + SHIFT + ENTER