UnPivot or Normalize Data using Pivot Table and PivotChart Wizard
Why Unpivot or Normalize Data? Data in a Report format may give you the insight of a particular aspect, but that report need not be good for further analysis or generating another report or reports. Following is a sample data in Report format. It is always easy to Filter, Sort, Slice or Dice data, when…
