Merge Excel Sheets & Pivot
Budget: $10 – $30 AUD
I have a collection of large Excel workbooks—some share identical headers while others carry their own unique columns. My goal is clear: bring every row into a single, well-structured table so I can run meaningful data analysis without chasing information across multiple files.
Here’s what I need:
• Examine each sheet, map matching columns, and sensibly align the unmatched ones.
• Consolidate everything into one master table inside a new workbook using Power Query or VBA—whatever keeps refresh simple.
• Add calculated fields where useful (totals, averages, percentages) to make the dataset analysis-ready.
• Build an interactive pivot table plus a slicer-driven summary view that lets me slice results by key dimensions such as date, category, region, or product.
• Provide brief documentation of your steps so I can repeat the process when new files arrive.
The merged file must retain every source row, avoid duplicates, and maintain column integrity. Accuracy is non-negotiable; I’ll be checking for perfect alignment between source and output.
If wrangling large data sets, Power Query, and pivot dashboards are part of your daily toolkit, I’d love to hear how quickly you can deliver and any questions you need answered to get started.
Here’s what I need:
• Examine each sheet, map matching columns, and sensibly align the unmatched ones.
• Consolidate everything into one master table inside a new workbook using Power Query or VBA—whatever keeps refresh simple.
• Add calculated fields where useful (totals, averages, percentages) to make the dataset analysis-ready.
• Build an interactive pivot table plus a slicer-driven summary view that lets me slice results by key dimensions such as date, category, region, or product.
• Provide brief documentation of your steps so I can repeat the process when new files arrive.
The merged file must retain every source row, avoid duplicates, and maintain column integrity. Accuracy is non-negotiable; I’ll be checking for perfect alignment between source and output.
If wrangling large data sets, Power Query, and pivot dashboards are part of your daily toolkit, I’d love to hear how quickly you can deliver and any questions you need answered to get started.