4 different methods to create a Unique list of records in Excel are explained below. Pivot Table Array Formula Remove Duplicates Advanced Filter To create a unique list of records for each item (Product,

Following is my trick to apply AutoSUM for multiple Rows and Columns. *Select the entire data range with an Extra Column and Extra Row *Press ALT + = If you have multiple worksheets with similar data ranges,

I just found out that PivotTable and PivotChart Wizard can be used to ‘Unpivot’ or ‘Reverse Pivot’ in Excel. I will explain the procedure by UnPivotting the table shown below. PivotTable and PivotChart