I will combine, clean and automate multiple excel files using power query
Power BI Developer and Visualization Expert
Revisado por el equipo de Fiverr Pro
El equipo de Fiverr Pro seleccionó a Borislav J por su experiencia.
Revisado para
Análisis de datos
Procesamiento de datos
Visualización de Datos
Acerca de este Servicio
Vetted Pro
Are you dealing with dozens or hundreds of Excel files that need to be manually opened, cleaned, transformed, and combined?
I can build a professional Power Query solution that turns multiple Excel or CSV files into one clean, structured, refreshable dataset.
I can help you with:
*Combining files or worksheets into one master table
*Importing files from folders and subfolders
*Cleaning and standardizing inconsistent data
*Handling different layouts, headers, and structures
*Extracting data from filenames and folder paths
*Merging, appending, pivoting, and unpivoting
*Creating custom transformation and mapping logic
*Removing duplicates, blanks, errors, and unnecessary rows
*Standardizing text, dates, numbers, and categories
*Building custom Power Query solutions using M language
*Creating refreshable datasets for Excel or Power BI
*Automating recurring reporting
The result: a clean, scalable dataset that refreshes when new files are added, without repeating manual work.
I handle simple consolidations and complex datasets with different structures and business rules.
Please contact me (!) before ordering so I can review your files and recommend the best solution.
Tecnología:
Excel
•
Otros

