Need to manipulate data in excel 2016 from one column to many columns

Hi I have hundreds of contacts in a single column in xlsx 2016. An example is shown below in the link, (sorry can't embed pic)

link to screenshot of data

What I need to do is bring all the data into individual columns as shown below

Col 1: Company Name, Col 2: Address, Col 3: Reg Head, Col 4: Tel Col 5 Fax: Col 7: Email

To throw a spaer in the works some addresses spread over 2 rows.

Any help is appreciated Thx