EXCEL PIVOT
EXCEL pivot table is a powerful data analysis and summarization tool that allows you to rearrange and summarize data          from a table or range of cells.
Insert Pivot table.
Select any cell on the table.
Click the Pivot table on the insert tab of the ribbon.
Select From Table/Range.
 Select the table Range.
by default, a New Worksheet is selected.
Click on OK
Excel will build an empty pivot table.
Excel will build an empty pivot table.
Add fields
Drag Product to Rows Area.
Drag Price to Values Area.
Add Product to Columns
Add Price to Values
