This code is a modification to the above post to have the cities adjusted under each other

Create TABLE #tempCityState (State Varchar(5), City Varchar(50))

Insert Into #tempCityState

Select 'CO', 'Denver' Union

Select 'CO', 'Teluride'...