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 it's summarize the data,average etcA pivot table is a data summarization tool that is used in the context of data processing. Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. It allows its users to transform columns into rows and rows into columns. It allows grouping by any data field.