Please provide sample rows and sample output. I would think at a minimum you would need to include the gender and distance columns so you can specify what the other values represent. This should be a trivial query if I am understanding your requirements (which will become crystal clear with sample/output).
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service