Pivot Table

Yesterday I was wondering about how to use Pivot tables in SQL Server with SQL, Thougtht  of share the concept with simple example.

What is Pivoting?
 Pivoting is reorganizing the table data. This can help to quickly summarize the flat data,and displaying information in a more useful way to interpret.

Following is the example

 After Pivoting