stumped on City State sort

I have a worksheet with all 50 states in column A, and the names of cities in those states listed in columns B through AZ.  I would like to change this so I see what state has each city name.  

An example is the city ‘Aurora, which is on the row for Colorado and the row for Illinois.  I would like to see a sort of some type that woud say put the names of the cities in column A, and the names of the states in columns B through whatever.  

 

Can’t figure this out…..

By: Steven Rusch

Leave a Reply

Your email address will not be published. Required fields are marked *