I have data in SQL Server that needs to be converted from columns into rows. Now although this question has been asked quite a lot in sometime, I was still facing some difficulty and hence I was wondering if someone can assist me. 

Currently the format is as below.

[![enter image description here](https://i.stack.imgur.com/CdXeF.png)](https://i.stack.imgur.com/CdXeF.png)

The table format that is required and that will be very helpful will be;

[![enter image description here](https://i.stack.imgur.com/WAI6c.png)](https://i.stack.imgur.com/WAI6c.png)

So not only the PIVOT needs to be applied but I am not sure which SQL Query syntax will help to identify the Type. I have tried using CASE-WHEN with PIVOT but that really yield correct output.

Regards!