---
title: "What is PIVOT and UNPIVOT?"  
description: "What is PIVOT and UNPIVOT?"  
author: "Anonymous User"  
published: 2011-05-11  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/883/what-is-pivot-and-unpivot  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What is PIVOT and UNPIVOT?

*A Pivot Table* can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, effectively rotating a table.

UNPIVOT table is reverse of PIVOT Table.

## Answers

### Answer by Anonymous User

*A Pivot Table* can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, effectively rotating a table.

UNPIVOT table is reverse of PIVOT Table.


---

Original Source: https://www.mindstick.com/interview/883/what-is-pivot-and-unpivot

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.