Windows XP Sorting info by rows and columns

[akcoots]

I need to sort these so that "Caucasian Male 2000" would = 2, "American Indian Female 1998" would = 1, and so on...

CaucasianFemale2003CaucasianMale1999CaucasianMale2000CaucasianFemale2000CaucasianFemale1999CaucasianFemale2003CaucasianFemale2001CaucasianFemale1999CaucasianFemale2001CaucasianFemale2001CaucasianFemale2002CaucasianFemale2001Prefer not to answerMale2000CaucasianFemale1999CaucasianMale2002CaucasianMale2001CaucasianFemale2002CaucasianMale2000CaucasianFemale2002American IndianFemale1998CaucasianFemale1997

Any ideas?

 

[akcoots]

These were in 3 columns and 21 rows. Sorry.

 

[akcoots]

DSL connection, CA Internet Security Suite anti-virus and firewall.