With this short and simple Python script you can easily transform unstructured and inconsistent address data to the format you like. It uses the free Google Maps Geocoding API.