Phoenix - Your AI AssistantAutomate Excel data cleaning using Power Query (1 dataset)
Delivery in
1 day
- Views 3
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will create a Power Query solution to clean and transform 1 dataset (Excel or CSV) into a structured and usable format.
This is a one-time automation setup for a single data source.
What You Get:
Power Query setup for 1 dataset (Excel or CSV)
Remove duplicates, errors, and blank rows
Standardize and clean columns (dates, text, numbers)
Merge or transform tables (if required within same file)
Create refreshable query (one-click update)
Basic M code implementation
Final clean output table in Excel
This is a one-time automation setup for a single data source.
What You Get:
Power Query setup for 1 dataset (Excel or CSV)
Remove duplicates, errors, and blank rows
Standardize and clean columns (dates, text, numbers)
Merge or transform tables (if required within same file)
Create refreshable query (one-click update)
Basic M code implementation
Final clean output table in Excel
What the Freelancer needs to start the work
1 sample Excel or CSV file
Required final output format (example sheet or description)
Basic transformation rules (if any)