UNPIVOT doesn’t reproduce the initial table-valued expression result since rows have been merged. PIVOT aggregates data and can merge a bunch of rows into a single row. It is only possible if the pivoted table doesn’t contain aggregated data. Nevertheless, note that UNPIVOT is not a complete opposite of the PIVOT function.

In order to reverse a PIVOT operator, that is, to convert data from column-level back to row-level and get the original table, you can use the UNPIVOT operator. PIVOT (AVG(price) FOR screen IN(,, ,, ) SELECT 'average price' AS 'avg_', screen, price FROM laptops) x To achieve this result in SQL Server, you need to run the following script: SELECT, ,, ,, If we pivot it by the first column ‘screen’, we will get the following result: It also enables us to perform aggregations, wherever required, for column values that are expected in the final output. We use PIVOT when there is a need to convert table rows into columns. The PIVOT and UNPIVOT relational operators are used to change a table-valued expression into another table and involve data rotation. To start, let’s give definitions and highlight the difference between PIVOT and UNPIVOT operators in SQL Server.

Convert a row to a column in excel