Power Query Dynamic Merge & Expansion
Power Query in it’s default form is simply glorious and allows any one with a basic knowledge to merge and collate data sets with the use of the excellent User Interface. But it comes at a price. Hard coding. Now you’ll find in many organisations where power query has been used to transform data and processes that most of the […]