Convert a vertical data in a excel sheet with one header

Question

I have a problem converting a long list of vertical address data into a a standard horizontal excel sheet with a header file.

What I have is this:

Name     Text Doe
Email    me@you.com
Operator     Someone
Product/Service  name of product
Phone   123 1234567
Company  ABC Company
Referrer URL     https://www.google.com.my/
Search Engine    Google
IP   210.186.133.177
Country/Region   Malaysia
State    Kuala Lumpur
City     Kuala Lumpur[Client Info]
Language     en-GB
Time Zone    GMT +08
Name     Text Doe
Email    me@you.com
Operator     Someone
Product/Service  name of product
Phone   123 1234567
Company  ABC Company
Referrer URL     https://www.google.com.my/
Search Engine    Google
IP   210.186.133.177
Country/Region   Malaysia
State    Kuala Lumpur
City     Kuala Lumpur[Client Info]
Language     en-GB
Time Zone    GMT +08
Name     Text Doe
Email    me@you.com
Operator     Someone
Product/Service  name of product
Phone   123 1234567
Company  ABC Company
Referrer URL     https://www.google.com.my/
Search Engine    Google
IP   210.186.133.177
Country/Region   Malaysia
State    Kuala Lumpur
City     Kuala Lumpur[Client Info]
Language     en-GB
Time Zone    GMT +08

I try to find some automated way to parse this into a standard excel sheet where the labels on the side are horizontal on the top with the info below so that I can import it to a crm.

Name     Email   Operator    Product/Service     Phone  Company  Referrer URL    Search Engine   Google    IP    Country/Region  State   City    Language    Time Zone

with the info on the cells below. Is there a easy way to do this in a VB script or any other way?