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.

 

 

Some of the solutions sent our way

• Benedicte Demas
• Egor Vaulin
• Ken Cromb
• Maribel Medina
• Melissa de Korte
• Michiel Schoonderbeek
• Peter Tholstrup
• Victor Momoh
• Vladimir Shamsutdinov