Currently I have a data sheet that looks like this:

_____A_______B___
1____A_____Data 1
2____B_____Data 2
3____A_____Data 3
4____C_____Data 4
5____B_____Data 5

I want to create a column that will sort and display and list all of the
"A's" in Column A, all of the "B's" in another column, all of the "C's" in
another column, and so on.

Basically I want it to read like this:
___A______B______C__
Data 1___Data 2__Data 4
Data 3___Data 5__

What I want to do is to sort and display names in separate columns based
upon a ranking format of A,B,C,D. I want all of the A's in one column, all
of the B's in another, all of the C's in a third, and all of the D's in the
fourth.

Currently, in my data sheet, the A-D ranking is in columns L7:L150, with the
names in columns M7:M150.

Any insight on how to accomplish this? Thanks for everyone's help.