Clean and Transpose Data with Microsoft Power Query in Excel.
$10-30 USD
Pagado a la entrega
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.
Nº del proyecto: #13295407
Sobre el proyecto
9 freelancers están ofertando un promedio de $33 por este trabajo
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 an Más
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 prov Más
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 Más
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 h Más
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.
