I have a list of hundreds of students that contains the following data. The only two values that will appear in the gender column (col 3) are male
or female
:
Current List
fName | lName | Gender | id#
----------------------------------------
Mike | Jones | male | 123456
Todd | Smith | male | 987654
Kim | Holly | female | 753951
I want to sort the sheet so it returns alternating values (male/female) in the gender column.
Desired List
fName | lName | Gender | id#
----------------------------------------
Mike | Jones | male | 123456
Kim | Holly | female | 753951
Todd | Smith | male | 987654