Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I group data on different rows together and then sort the grou
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! |