by
Asim Ali , Store superviser , mayfairAsain food indusrty manga rawind road pakistan
Arrange your data in columnar format
Assign column names to your sorted data range
Go to Insert tab and Insert pivot table on the extreme left side of the tab
It will demand the pivot table range where you enter the table or data range
Below the table range is the option to allocate the pivot table in the existing worksheet or in the new worksheet.
Press ok.
Here is your requested pivot table
After this when you go to pivot table sheet. Two optional tabs after the view tab appears which are called the formatting tabs
You can change the layout design, color and other formats in your pivot table