Find Jobs
Hire Freelancers

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

$40-70 USD

Ολοκληρώθηκε
Αναρτήθηκε πάνω από 5 χρόνια πριν

$40-70 USD

Πληρωμή κατά την παράδοση
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.
Ταυτότητα εργασίας: 17642001

Σχετικά με την εργασία

13 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
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 σε 3 ημέρες
4,2 (69 αξιολογήσεις)
5,8
5,8
13 freelancers δίνουν μια μέση προσφορά $62 USD για αυτή τη δουλειά
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 σε 1 ημέρα
4,9 (403 αξιολογήσεις)
8,3
8,3
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 σε 3 ημέρες
5,0 (432 αξιολογήσεις)
7,7
7,7
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 σε 1 ημέρα
5,0 (171 αξιολογήσεις)
6,7
6,7
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 σε 2 ημέρες
4,9 (156 αξιολογήσεις)
6,8
6,8
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 σε 5 ημέρες
5,0 (100 αξιολογήσεις)
6,5
6,5
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 σε 1 ημέρα
4,8 (14 αξιολογήσεις)
5,3
5,3
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 σε 2 ημέρες
4,9 (34 αξιολογήσεις)
5,3
5,3
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 σε 5 ημέρες
5,0 (10 αξιολογήσεις)
4,0
4,0
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 σε 10 ημέρες
5,0 (4 αξιολογήσεις)
2,9
2,9
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 σε 2 ημέρες
4,6 (7 αξιολογήσεις)
3,1
3,1
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 σε 10 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Chicago, United States
5,0
8
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Φεβ 2, 2015

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.