Clean and Transpose Data with Microsoft Power Query in Excel.
$10-30 USD
Cancelled
Posted about 7 years ago
$10-30 USD
Paid on delivery
I’m looking to clean up and transpose some data obtained from a web page(s), specifically using Microsoft Power Query in Excel. I can provide you the raw data and a suggested layout of the cleaned data.
(Note that I’ve done it with VBA, but I’d like to see if there are advantages in using Power Query.)
Points to note:
- Power Query does not recognise data on the chosen web page, but importing data does work using Excel’s Data tab and selecting “From Web”.
- The data layout looks good on the web page, but some rows are incorrect after import.
- The main steps would involve filtering out null values, filling down, removing blank rows, correcting errors, selecting the correct data type, and transposing rows.
I would view this as a micro project for someone familiar with Power Query.
Feel free to ask for clarification if you need it.
Hello Sir,
Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Automated Web Scrapping using Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done.
Also I will provide you with a sample file before you consider awarding me the project.
Thanks,
Jay
"Rate and duration will be fixed on discussion"
Dear Hiring Manager,
I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
--
Kinds Regards,
Mehedi Hasan.
5th March (5)
Hi there!
I am an expert on any data entry jobs and I’ve lot of experience on this type projects..
I’m ready to start it right away.
I look forward to hearing from you.
Regards
Dear sir
I will start now
I am web research, data entry and copy typing specialist. My typing speed is 100 word per minute. I am honest and hard worker. I will start now and deliver you before your deadline. I provide quality work and 100% accuracy for my respectable client. So please consider my bid. I AM READY TO GIVE YOU A TEST. TEST ME BEFORE HIRING.
Regard
Manwar
Dear Hiring Manager,
I want to do your job/project now, let's start immediately. I have read the job description.
I've been working in a BPO company for more than 13 years now. My job there honed my skills to be a web search expert, MS Excel expert & MS Word expert. I have good analytical skills and I'm very keen to details. I'm a returning freelancer (not searched and accepted jobs/projects for a few years) so please give me a chance and read my past reviews. My typing speed is 35wpm. I'll try my best to complete it on time and I guarantee 100% accuracy in all my works.
I'm available for work on your job/project at this Philippines times (UTC/GMT +8 hours):
5 hours during weekdays (10am-3pm PHT)
10 hours during weekends (10am-8pm PHT).
Regards,
Oliver
My profession is programming. I am also working a lot with data entering, rewriting, copywriting projects. I kindly invite you to cooperate with me. Greetings
Hello,
This is Jubaer. I have read your job details. I am interested on it . I have done many job like this for my local client. I am 100% fit for your job. I can easily complete your job within a short period. I have lot of experience on Data Processing, Excel . As a expert I will try my level best to do your task. I hope your kind response.
Regards
Jubaer
With regards to your Project, I am well versed with Power Query and i believe that, I will be able to help you out with your job request. So give me a chance to serve you and you won't be disappointed.
