Vistaar Finance interview question

What is pivot table and why we are using that?