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
• 13,640 points
42 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
• 13,640 points
899 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 gaurav
• 22,040 points
142 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 gaurav
• 22,040 points
2,040 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 gaurav
• 22,040 points
2,672 views
0 votes
0 answers

Backup a single table with its data from a database in sql server 2008

I want to use a script to ...READ MORE

Aug 29 in Database by Kithuzzz
• 20,660 points
49 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
1,077 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
• 8,940 points
1,188 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 gaurav
• 22,040 points
179 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP