Monday, September 30, 2013

Multiple Consolidation Ranges in Excel

So I was watching this +Bill Jelen video and noticed how he was normalizing data - his data was not normalized and he used a Mike Alexander technique - he fed the data into a Pivot Table and then used the Pivot Table to generate an extract, thus normalizing the data in a new sheet. Have a read of the background Microsoft documentation on Multiple Consolidation Ranges.

No comments: