如何在两个级别上转动

I am using SQL Server 2012 and am trying to construct a pivot table from TSQL based on the table below which has been generated by joining multiple tables. I am using SQL Server 2012 and am trying to con