Help with Advanced Filtering/Data Formatting

Hello all,

I've just received a delimited data set from a web app and the data is incorrectly formatted. If the user did not enter data into a field it skipped the field. All of my data has been imported and it has a prefix before the data (ie First-Name:, State:, Zip: ) in each cell then the value.

I need to move each value with a certain prefix to a new column, ie moving all data in the worksheet containing First-Name: to column A, Last-Name: to column B and so on so that the data is formatted correctly. I've tried to do this via the filtering and advanced filter to no avail. I'm also a macro newbie and not sure how to put one in that would manually do this for each prefix I need. Any help is greatly appreciated. Thanks.

I have attached some sample data. In the sample, I would like to move all data in cells that contain the string "City:" to Column D1, all cells with "State:" to E1 and all cells with "Zip:" to F1.