Use the Pivot feature to reorient the axes of a pivot table and view your data in new ways. pivoting a table enables you to more easily compare the new data to data in the originating table, which makes pivot tables more powerful than common spreadsheets.
By default, pivot handles are transparent. They only appear when you select a label from a top or side. When the pivot handle appears, it is shown in white with a light grey handle (
). Once the selection is off, the pivot handle is transparent again
To pivot