Tech Mahindra Interview Question

What is pivot table and how do you use it?