I will clean and transform your excel data using power query

AldoBI

Morocco

I speak English, Arabic, French, Spanish

Analyst Excel and Power BI

Phd Marketing and Logistics, I spent 10 years in third party logistics and supply chain. also I worked in many projects of process implementation let you inspired by our Gigs
About this Gig

Are you dealing with a messy Excel spreadsheet filled with bad formatting, duplicate entries, merged cells, or missing values? Spending hours cleaning data manually is a waste of your valuable time.

I will fix, clean, and automate your data transformation process using Power Querythe most efficient tool for handling raw data.

What I can do for you:

  • Data Cleanup: Remove duplicates, extra spaces, unwanted characters, and fix inconsistent date/number formats.
  • Data Transformation: Unpivot columns into rows, split columns (e.g., First Name / Last Name), and restructure tables for analysis.
  • Data Merging & Combination: Combine multiple sheets, CSV files, or entire folders into one master sheet automatically.
  • Automation: Set up dynamic Power Query queries so you can refresh your clean data with just one click whenever new data arrives.
  • Custom Logic: Apply conditional columns, custom formulas, and validation rules.


Please send me a message with a sample of your messy file before placing an order so I can confirm the scope and give you the best custom offer!

Read More
clean and transform your excel data using power query
Full Screen
clean and transform your excel data using power query

My Portfolio

Related tags