Question: why pivot table is used in excel?
Answer: 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. ... Pivot tables are the perfect solution when you need to summarize and analyze large amounts of data.