Pivot Table is used when we want to transfer data from row to column. It helps us to create interactive tables that quickly compare and combines a large amount of data.

For more detail, you can read about it in my article Pivot Table In SQL