What is Pivot Table..........

There are two words in Pivot Table

  

1.Pivot and

2.Table

Pivot

Literal meaning of Pivot is as follows:

The central point, pin, axis or shaft on which a mechanism turns or oscillates.

Table

Literal meaning of Table is as follows:

A set of facts or figures systematically displayed, especially in rows and columns.

Pivot Table

Pivot Table is a mechanism, a tool or an interactive table by which we can rotate rows and columns quickly and easily to organize, summarize, analyse, and compare large amounts of data without having to build complex formulas.