How to efficiently transform messy Excel files in Power Query?
Reddit r/PowerBI1d4 min read
Title: Best way to transform complex weekly Excel files in Power Query? Hi everyone! I'm building a Power BI report for workforce planning, working hours, and employee absences/deviations. My data comes from a SharePoint folder organized by year, with approximately 52 Excel files per year (one per week). Each workbook contains multiple worksheets for day, evening, and night shifts. The main problem is that the Excel files have a fixed, complicated structure that I cannot modify. They contain multiple tables within each worksheet, blank rows/columns, and different sections for schedules and dev