Try formula in B4:

=IFERROR(INDEX('Filled Positions'!C$9:C$45, SMALL(IF('Filled Positions'!$A$9:$A$45=$A$1, ROW('Filled Positions'!C$9:C$45)-ROW('Filled Positions'!C$9)+1), ROWS($B$4:$B4))),"")
CSE confirmed and copied down and across (Note: you may need to make adjustments to INDEX range to get right column(s).