Copy Column A rows based on Column B value

I am having a problem trying to figure out how to fill 3 columns with data from column A, based on value in column B.

I have a list of employees in Column A.
I have their deployment ranking (1, 2 or 3) in Column B.

I want to fill in 3 columns to the right with a list showing all employees who have a ranking of 1 in the first column, all employees with a ranking of 2 in the next column, and all employees with a ranking of 3 in the last column.

I have attached a copy of the Excel spreadsheet to this post for a clearer view of what I am trying to do.

Any help would be greatly appreciated.

Try this array formula

=IF(ISERROR(SMALL(IF($B$2:$B$100=COLUMN(A$1),ROW($B$2:$B$100)),ROW($A1))),"",
INDEX($A:$A,SMALL(IF($B$2:$B$100=COLUMN(A$1),ROW($B$2:$B$100)),ROW($A1))))

copy down and across.

Thanks for the help.

When I use this array, and then copy it down and across, it puts the same entry from cell A2 into the cells across all 3 columns, and notihing in the cells below. When I change the value of cell B2, there is no change in the values in the columns to the right.