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.
프로젝트 ID: 17642001

프로젝트 정보

13 제안서
원격근무 프로젝트
활동 중 6년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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 이 프로젝트에 프리랜서들의 평균 입찰은 $62 USD입니다.
사용자 아바타
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
사용자 아바타
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
사용자 아바타
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
사용자 아바타
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
사용자 아바타
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
사용자 아바타
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
사용자 아바타
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
사용자 아바타
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
사용자 아바타
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
사용자 아바타
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
사용자 아바타
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월 2, 2015부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.