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.
