UNPIVOT in SQL Server

In last post i tried to demonstrate how can we use PIVOT in SQL Server.
In this post i am just going to describe where we can use UNPIVOT.

Let’s create an example for this.
I will take sample data from my last post.

This is our sample data and now i want to display this data as below format.

Here is T-SQL

That’s It.
Enjoy Learning.