How to write query for display data in SQL.

Question

I have table in MS SQL as show below.

 

I want the Output like as show below image  without using any temporary table in SQL server.so please help me.