Address Book Sort into different Columns

Hi

Need help to sort out address book details into seperate columns. I have attached an example the raw data (which always appear in same format with same gap) shown in yellow (COLUMN A) and on the right how it should be presented. The address details needs to be split (not sure how to do) which is the 1st & 2nd line can be presented with Company Name appearing in Address 1 and the address details before the 1st coma appearing in column Address 2 and the following after the 1st coma appearing in Address 3 The last comma after which the post code appears should be shown in G column.

Either a formula or macro would do or any help to show as to how to do this. Please ask if any questions.

Thanks