by Wyn Hopkins

Flexible Consolidation of Tables

These 2 tables exist on their own tabs in this file, goal is to combine them in a flexible way to produce the output required :

 

  1. Must replace nulls with 0s
  2. Must be able to handle a completely new table for a new Region being added
  3. Must be able to handle changes to the Zone Names, or new Zone Names being added to any region Table
  4. Output to be Sorted by Date then Zone then Region

Output Required – 80 Rows initially (but must be refreshable and handle scenarios mentioned above)

And here’s how we’ve done it…

Download the solution file here.

Free Download

 

 

Some of the solutions sent our way