UnPivot Example

The following is an example of how to use the SQL UNPIVOT function. This function is almost the opposite of the PIVOT function.
The UNPIVOT function takes specified columns and output them as rows.
Start with a table, [PivotExample2], with the following data:
RowIDGrpAAABBCCDD
1XXX9112316
2YYY30188NULL


To takes the values in columns [AA], [BB], [CC], & [DD], use the following query:
select up.GrpA, Val
from PivotExample2 a
unpivot
(
   Val for Val1 in (AA, BB, CC, DD)
) as up

The above sql results in the following output:
GrpA|Val
XXX9
XXX11
XXX23
XXX16
YYY30
YYY18
YYY8

Related


Last modified by Mohit @ 4/5/2025 7:59:35 PM