Rolling cube example

I have 16 players that roll number cube (1,2 ...6) once.
In Column A I have player's names and in column B score.
What I would like to do is to list all players that got 1 in column E,
all players that got 3 in column F ... and all that got 6 in column J.
Like in attached example, where John and James got 1 and they are both listed below 1 in column E.


I wonder if that is possible without macros.

In general I would like to "filter" data in particular column of selected table
and then list results of each such value of that particular column in the same order as it is in the original table.