Replacing Words in Respective Rows

Hi, I am trying to replace each occurence of these items:

{city_name}, {state_name}, {state_abbreviation}

with its corresponding city, state and state abbreviation in these columns (the first three):

city_name state_name state_abreviation

So, for example, column D, Row 2 would read: "Atlanta Widgets - See Widgets in Atlanta, Georgia"

All cities and states need to be in title case except the slug needs to be in lowercase.

The attached file is only a sample of the thousands of rows.

I hope this is clear. Thanks in advance.