Sorting matrices into different categories

Hello,

I am really struggling to figure out the following problem so would really appreciate any advice!

I have a excel file that has 5 columns and 18000 rows which follows the sample data attached above.

The fifth column identifies the position the person plays in and I need the data to be sorted so that the two different positions are in two tables/matrices which can then be individually manipulated.

Then, I need to sort column 4 (names) so that the same names are grouped together in the separate matrices.

I have tried to represent this in the sample.

I hope this makes sense.

[Jan]

"The fifth column identifies the position the person plays in and I need the data to be sorted so that the two different positions..."

The 5th column contains one position, e.g. "forward". So which "two different" positions are meant?

What does "individually manipulate" mean? What are "separate matrices"?

[KPSil]

The two different positions are forwards and back. I need to split the data into two tables. Which can then be separately run through another function so their results can be compared.