Tags: ALT+D+P

Converting a matrix data layout to a tabular layout

{ 74 Comments }

In this file, the source data sheet is a pasted special pivot table.  The task is to convert this pivot table data layout to the result shown in the “Desired result” sheet.  Effectively, we need to convert a matrix like data layout to a tabular layout.  We need to “denormalise” the pivot table. Solution for […]

Read More →