What is Pivot and Unpivot
| We can sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data with the Pivot tables. The PIVOT operator turns the values of a specified column into column names, effectively rotating a table. UNPIVOT table is reverse of PIVOT Table. |
|