God morning the greatest Team
Please, I am requesting your expertise in merging and consolidating multiple workbooks in Excel using Power Query.
I have budget sales data spread across two workbooks, each representing a different town (K Town, New Layout). Each workbook contains four worksheets, with each sheet representing a different quarter (Q1, Q2, Q3, Q4) of the budget year.
My goal is to consolidate all of this data into a single table, organized by quarter, town, and product. I would be incredibly grateful if you could guide me through the steps using Power Query.
Thank you in advance for your valuable assistance.
Best regards,
Please, I am requesting your expertise in merging and consolidating multiple workbooks in Excel using Power Query.
I have budget sales data spread across two workbooks, each representing a different town (K Town, New Layout). Each workbook contains four worksheets, with each sheet representing a different quarter (Q1, Q2, Q3, Q4) of the budget year.
My goal is to consolidate all of this data into a single table, organized by quarter, town, and product. I would be incredibly grateful if you could guide me through the steps using Power Query.
Thank you in advance for your valuable assistance.
Best regards,