Excel Template to Transpose Cut & Paste Data into Logical Data Table

I'd like to have an Excel worksheet with macros or other logic created that will take data copied from a web page and transpose that data into logical columns (fields) and rows (records) I have enclosed an Excel worksheet with a sample of the pasted raw data (Sheet: Original Data Input) and the output desired from that data (Sheet: Output). Please note that I have only included the first 20 records as rows in the Output sheet. Other things to pay attention to: 1. The "Contributed By" name must be broken up into first and last names 2. Not all addresses have both the street address and unit/apartment/PO box identified 3. When a unit/apartment/PO box is identified, it must populate the field "Address 2" 4. Not all records have Employer or Occupation data. 5. A few records will have Employer data but not Name data. 6. Zip codes must be broken up into the first 5-digit zip portion (Column: Zip) and then the following 4-digit zip portion (Column: Zip2) 7. Data in the Zip and Zip2 columns must be prefixed with a hypen ' to make it an Excel text field. The data is pulled from: [login to view URL] Please contact me with questions.