I am looking for a way to be able to group data on subsequent rows together
and then sort those groups into a list. My data looks something like this:

(Column 1) (2) (3) (4) (5)
Smith, Joe 1 2 3 A
5 6 B

Doe, John 1 2 3 A
5 6 B

Doe, Jane 1 2 3 B
6 5 A
7 8 9

I need to be able to group each "person" in column 1 together with the data
in the next 4 columns and following rows. Then I need to sort the groups so
that every "person" with a "3" in the 4th column together. See what I mean?
Can I do this and if I can, how?
Thanks!