define pivot table and why we use it in Microsoft excel?explain it briefly.
A pivot table is a table of statistics that summarize the data of a more extensive table and we use a pivot table to build a list of unique values. Because pivot tables summarize data, they can be used to find unique values in a field.