Find Jobs
Hire Freelancers

Excel Template to Transpose Cut & Paste Data into Logical Data Table

$40-70 USD

Completed
Posted over 5 years ago

$40-70 USD

Paid on delivery
I'd like to have an Excel worksheet with macros or other logic created that will take data copied from a web page and transpose that data into logical columns (fields) and rows (records) I have enclosed an Excel worksheet with a sample of the pasted raw data (Sheet: Original Data Input) and the output desired from that data (Sheet: Output). Please note that I have only included the first 20 records as rows in the Output sheet. Other things to pay attention to: 1. The "Contributed By" name must be broken up into first and last names 2. Not all addresses have both the street address and unit/apartment/PO box identified 3. When a unit/apartment/PO box is identified, it must populate the field "Address 2" 4. Not all records have Employer or Occupation data. 5. A few records will have Employer data but not Name data. 6. Zip codes must be broken up into the first 5-digit zip portion (Column: Zip) and then the following 4-digit zip portion (Column: Zip2) 7. Data in the Zip and Zip2 columns must be prefixed with a hypen ' to make it an Excel text field. The data is pulled from: [login to view URL] Please contact me with questions.
Project ID: 17642001

About the project

13 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I am an excel VBA expert and I have done many similar projects. Usually, most of these projects cater to the forex exchange industry with the complicated output. This one is slightly easier. I would like to take this project and give you a quick turnaround Hope to chat with you soon Thanks Sajid Khan
$60 USD in 3 days
4.2 (69 reviews)
5.8
5.8
13 freelancers are bidding on average $62 USD for this job
User Avatar
Hi there, I have gone through the link and the output sheet. it can be done by our excel shortcuts, formulas and knowledge of experience. we can get you the out put as your requirement. Thanks IF YOU CONFIRM NOW, WE ARE READY TO START IMMEDIATELY
$70 USD in 1 day
4.9 (403 reviews)
8.3
8.3
User Avatar
Hi, An example video has been attached in my portfolio named "Pull Data From Web". I am interested in your project and I would like to know more details.. Kindly see the video & drop a message so we can discuss. Thanks.
$55 USD in 3 days
5.0 (432 reviews)
7.7
7.7
User Avatar
Hi there, I have already carefully gone through your requirements and I would like to work with you in this project!!I am ready to start your work. Regards, Mou
$40 USD in 1 day
5.0 (171 reviews)
6.7
6.7
User Avatar
Hi there, I’ve checked the project details and I can do this perfectly. I have huge experience in working with these projects. Waiting for your quick reply. Look forward to hearing from you soon. Best Regards
$100 USD in 2 days
4.9 (156 reviews)
6.8
6.8
User Avatar
Hi, I have checked your project description and the attached file. I will able to design the macro to achieve this goal for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please allow me this to work with you on this project. I always deliver high quality work with full customer satisfaction. Thanks and regards, Mohan
$40 USD in 5 days
5.0 (100 reviews)
6.5
6.5
User Avatar
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 30 + projects with 100% client satisfaction. I can help you with Excel Template to Transpose Cut & Paste Data into Logical Data Table I have more than 5 years of the experience in Data Entry, Data Processing, Excel, Visual Basic Please ping me for more discussion. Thanks.
$70 USD in 1 day
4.8 (14 reviews)
5.3
5.3
User Avatar
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$70 USD in 2 days
4.9 (34 reviews)
5.3
5.3
User Avatar
Hi i read your description and attachment. i am sure i can handle your request. I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development
$61 USD in 5 days
5.0 (10 reviews)
4.0
4.0
User Avatar
Hello!!!! Thank you for the opportunity. I checked your requriement and got the idea what you are lokoing for in excel . Please describe the details on chat. As per your requirement, I would like to tell you that I have a very strong experience of more than 3 years in the field of data entry and data processing. I would also like to mention that I have expertise working over here and will provide you 100% result on time. Please, let me know what is needed to secure this bid! Thank you for your consideration.
$50 USD in 10 days
5.0 (4 reviews)
2.9
2.9
User Avatar
Hello, I've taken a look at your file and will definitely be able to automate the file according to your specifications. Best regards, Tom
$70 USD in 2 days
4.6 (7 reviews)
3.1
3.1
User Avatar
I've recently completed this same task for an Age Analysis .csv file for a Department Finance Officer at my University. I love these transposing projects and would be more than happy to help you with yours. Cheers, Ivor
$55 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Chicago, United States
5.0
8
Payment method verified
Member since Feb 2, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.