My Excel spreadsheet has a column of some 200 names in random order.

How do I sort a particular name in a cell and group it together.

Example: To group all "MR A" cells together

Current column

MR A
MR B
MR C
MR A
MR C
MR B
MR A
MR X
MR A

Required column

MR A
MR A
MR A
MR A


Thanks.
_____________