Find Jobs
Hire Freelancers

Require Power Query expert to transform and transpose Excel data

$10-30 AUD

Closed
Posted about 3 years ago

$10-30 AUD

Paid on delivery
Please refer to the attached example file. I am looking for robust and simple Power Query code to transform the data that is in Sheet1 to that in Sheet2.
Project ID: 29028113

About the project

35 proposals
Remote project
Active 3 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
35 freelancers are bidding on average $25 AUD for this job
User Avatar
Hi sir, I have checked the attached file, everything is clear and I am interested in working on this project. Please contact me to discuss further details!
$30 AUD in 1 day
4.8 (220 reviews)
7.1
7.1
User Avatar
Hi , I went through the job. I can put a macro to transform the data in Sheet1 to the format as you mentioned in Sheet2. I can complete the job within 30-45mins. Please ping back. Please check my reviews. Thank You Regards Rishi
$25 AUD in 1 day
4.9 (156 reviews)
6.0
6.0
User Avatar
Hi, The task is completed . we can connect and discuss. also explain the kit column logic ( how to tag yes and no). I have 10+ years of experience in vba programming and database management. And worked many similar project and completed it with 100% accuracy. Thanks Shivani
$25 AUD in 1 day
4.6 (22 reviews)
4.0
4.0
User Avatar
Dear Employer, I can help you to transform and transpose Excel data. I have good experience in power query, Power BI and excel. Regards, Sunil
$30 AUD in 1 day
5.0 (2 reviews)
3.2
3.2
User Avatar
Hi, I am a candidate with experience in PowerBI and SQL server, have knowledge on ETL data warehouse concepts and getting data on PowerBI gateways and services using query and building reports. I have previously worked on PowerBI dashboards and well versed with DAX functions, integrating SharePoint/SQL data to PowerBI, auto refresh data on PowerBI, building custom KPIs and visualization with storyboarding. Making reports available to everyone using PowerBI reports and services. You can find few work samples on my freelancer portfolio DM me so that we can discuss further Regards, Sangamesh KS
$10 AUD in 1 day
5.0 (6 reviews)
3.3
3.3
User Avatar
please give me the opportunity to do your job. I will do my best effort . . . . . . . Greetings! My name is Kamlesh Kumar and I am a full-stack web developer. I believe my skills match your project. I have a good grasp of working with PHP. I see your job description. I am ready to start working right now. I would be easily able to achieve the task. I believe communication is the key to every successful project. I look forward to discussing your project with you. Sincerely, Kamlesh Kumar
$25 AUD in 1 day
5.0 (3 reviews)
2.6
2.6
User Avatar
I have checked the attached file and can definitely help you with this data transformation. I just have 1 question which I would like to discuss with you. I am a power query and power BI expert and can quickly complete this task for you.
$30 AUD in 7 days
5.0 (4 reviews)
2.6
2.6
User Avatar
hey, My name is Stefano Grimaldi Matos, I am an industrial engineer by profession, I have 4+ years of experience in the fields of data analysis, generation of reports for decision-making and management meetings, economic evaluations of projects, process design, solution development of BI, active member of the Power BI community, as an independent consultant for more than 1 year, this a simple request, already have the M code for the tranformation.
$15 AUD in 1 day
5.0 (4 reviews)
2.5
2.5
User Avatar
I can implement required transformation using Power Query in a most qualitative way because I am BI developer with long term professional experience.
$67 AUD in 1 day
5.0 (2 reviews)
2.0
2.0
User Avatar
Quick and simple task. I will be able to complete this promptly and with the desired result.
$20 AUD in 1 day
5.0 (2 reviews)
1.3
1.3
User Avatar
Respected Client, Software Engineer Available 24/7 I am professional with 2+ years of experience,i assure you that i will deliver you quality work within your deadlines. I am available here to give services regarding VIRTUAL ASSISTANT which includes data entry listings customer support editing video word excel writing presentation My priority is to understand the client need and vision in order to be efficient and get the work done. My Motive is to make my employer happy without adding additional charges. Thank you in advance for your consideration
$35 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hi my name is naveed khan i am sure i can complete this project within the given time. i will start right now. thanks
$15 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello dear Sir! I am expert to transform and conduct data using Microsoft Excel and Office with right and proper formatting with high accuracy. I believe I can conduct robust and simple Power Query code to transform the data that is in Sheet1 to that in Sheet2 like you requested and for your information, all skill required by you is my specialist. I really hope you can hire to complete this project with zero mistakes. Please contact me for few samples before we have a deal. Thank you. Regards, Adli
$20 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 7 years experience in excel and data entry and I will done this project in given time period. give me this opportunity
$16 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir/Madam here I am looking a job I'm expert in Excel work so you will be believe MI and trust me
$15 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, I will perform accurate web search to collect the required information from your Facebook account by following all your steps and instructions and input all data into an excel spread sheet. Let's start with a few examples for a quality check and fix the best budget for this project. I am a professional web researcher and data entry expert. I have good keyboard skills to produce high quality documents. I also have experience about administration. I can use computer software packages, including Word, Excel and PowerPoint. My education background helps me to perform this task. I also make sure that I can produce neat and well-presented work. Let's discuss further to get started with the project, awaiting your prompt response Thank you Regards Asmah Hani Abdullah
$20 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have seen your requirement. I am able to do the task within the time frame. If you are ok, we can discuss in detail about this requirement. I have 7 years of experience in Data Analysis, Data warehousing ,Business Intelligence and certified in Power BI. I have built so many Power BI reports and have experience in building report using different data sources. I have knowledge on below skills, Power BI,SQL Server ,SSIS , SSAS,Azure Analysis Services, Data Bricks, Data Warehousing ,Business Intelligence Experience in below Business Area 1. Health Care Analytics 2. Supply Chain Analytics I have completed following certification 1. Analyzing and Visualizing Data with Microsoft Power BI.
$20 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Greetings, Thanks for reading my response to your project. I have gone through your assignment and I am confident of working with Power BI. I have more than 5 years of experience in working with Power BI and I am also a trainer. I can do this task in a day for you in a day. What is the data source for Power BI working? If interested, please open PMD (message board) so we can talk and possibly move forward. Looking forward to your positive response. Abid Maqsood
$10 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi can I help you with your project, I have years of experience and we have the excel 2016 certification best regards
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Certified DA-100 Microsoft Power BI Data Analyst. M,Dax, Dashboards Data modeling: tabular and multidimensional
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Brisbane, Australia
4.9
31
Payment method verified
Member since Jun 1, 2016

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.