Sort Data without using code

Can a sorted array be produced from a table without using code? The attached sample gives a better idea of what I'm trying to do.

Thanks

Like so...change the categories to a numerical index, then grab the "first" values of each number into the "Desired Outcome" chart.

E5: =IF(AND($B5=$E$3,$C5=E$4),N(E4)+1,N(E4))
...copied down and over onoe column.

G5: =IF(AND($B5=$G$3,$C5=G$4),N(G4)+1,N(G4))
...copied down and over onoe column.

J5: =IF(MAX(E:E)<ROWS($1:1), "", INDEX($A:$A, MATCH(ROWS($1:1), E:E, 0)))
...copied across and down the whole chart.

You can't add 1 to a text value. I want to use a single formula for the whole column and add 1 to the index from the value above if the row matches the criteria, but this won't work in the first row because the values above the first row are text strings ("tackle" and "block").

In this usage, n(E4) means "give me the numeric value of E4"...which is 0. By using this format, I can write the formula in E5 and just copy down.