Excel Hack 91: Normalize a matrix dataset using Microsoft Excel formulas (no macros needed)
When working with tables of data, the table set up usually encountered is the cross-tabulated or matrix data format. However, this dataset is not optimized for further analytics in Business Intelligence software like Tableau or Power BI. These software require datasets to be set up in a manner that ensures that a row represents a