Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate, clean and transform excel data with power query
About this Gig
Need help with Power Query in Excel?
I will clean, transform, merge, append, and automate your Excel data using Microsoft Power Query.
I can help you turn messy or repetitive data-processing tasks into a refreshable Power Query workflow.
What I can do:
- Clean and transform Excel data
- Merge multiple Excel files
- Append tables and datasets
- Combine files from folders
- Remove duplicates and errors
- Split and combine columns
- Change data types
- Create custom columns
- Write and fix Power Query M formulas
- Automate repetitive data preparation
- Build refreshable queries
- Connect multiple data sources
- Prepare data for PivotTables and dashboards
- Fix existing Power Query errors
Why use Power Query?
Instead of manually cleaning the same data every week or month, I can build a query that lets you refresh the process automatically.
Send me your Excel file and explain what you want the final data to look like. I'll create a clean and reusable Power Query solution.
Platform:
Excel
•
Google Sheets
•
Power BI
Development technology:
VBA
•
Excel
•
Power BI
Expertise:
Formatting
•
Formulas
•
Functions
•
Dashboard
•
Modeling
FAQ
Q: Can you fix an existing Power Query?
Yes. Send me the workbook and explain the error or expected result.
Q: Can you combine multiple Excel files?
Yes. I can combine files from folders and standardize their structure using Power Query.
Q: Can you write Power Query M code?
Yes. I can create, modify, and troubleshoot custom M formulas.
Q: Can you automate a recurring report?
Yes. I can create a refreshable Power Query workflow for recurring data-processing tasks.
Q: Can you work with CSV files?
Yes. I can import, clean, transform, and combine CSV data.
Q: Do you work with large datasets?
Yes, depending on the structure and complexity of the data.
