Excel, Accelerated: Transform grid into dimensional database

Task: Transform a grid into a dimensional database Context: Profit & Loss by property Acceleration techniques: Function: COUNTIF Technique: Absolute referencing ($A$1) Function: INDEX Function: MATCH Time: 2:21