Macro to convert mailing address list into excel table

Hi,

I have mailing addresses in an excel file (Please check the file attached).

I need to split the address into the following fields and write to the table: (please check "final" work sheet in the file attached)
First name, Last name, Company, Address, City, State, Zip Code, email address, phone number1, phone number 2, phone number 3

There are few complexities like:
some addresses has more than one phone number. Some doesn't have the company name.

Please help me in creating a macro or formulas to be able to create a table with the available data.

Thanks in advance,

Ravi.