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?
