Consolidating and Enriching Multiple Excel Sheets

In excel it happens often that multiple sheets should be consolidated in one and that should be enriched with a higher level grouping. In this short post I’m showing you how you can use Power Query to do that in a dynamic way in no more that 3 minutes.

Cheers!