Convert a vertical data in a excel sheet with one header

0 votes

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?

Apr 7 in Database by Edureka
• 9,320 points
9 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
1 answer

How to transform multiple tables in one excel sheet to one table with Power BI?

If my prediction is correct- You have a ...READ MORE

answered Apr 4 in Database by Edureka
• 9,320 points
30 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
37 views
0 votes
1 answer

How can I calculate deciles with a range of 12,000 cells in excel?

1. Enter the following formula in cell ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
51 views
0 votes
1 answer

Maximum number of rows of CSV data in excel sheet

The maximum number of characters per cell ...READ MORE

answered Apr 6 in Database by Edureka
• 8,820 points
44 views
0 votes
1 answer

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,830 points
925 views
0 votes
1 answer

How to drop all tables from a database with one SQL query?

Use the INFORMATION_SCHEMA.TABLES view to get the ...READ MORE

answered Feb 4 in Database by Neha
• 6,260 points
92 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

answered Feb 21 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

how do I calculate discount with if function in excel?

Suppose a customer gets a 10 percent ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
149 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP