Explain pivot tables and its uses?

A pivot table is a data summarization tool that allows you to summarize and analyze large amounts of data. It's a programming tool that is used to summarize, sort, reorganize, group, count, total or average data stored in a database.

Pivot tables allow its users to transform columns into rows and rows into columns.