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