Something like this...

IF OBJECT_ID('tempdb..#temp', 'U') IS NOT NULL

DROP TABLE #temp;

SELECT

x.Date,

x.Type,

x.Value

INTO #temp

FROM ( VALUES

('2016-09-16 00:00:00.000', 'Schema', 'dbo'),

('2016-09-16 00:00:00.000', 'Table', 'Employer'),

('2016-09-16 00:00:00.000', 'Index', 'EmployerIdx'),

('2016-09-16 00:00:00.000', 'fragmentation', '43.851409052'),

('2016-09-16 00:00:00.000', 'page_count', '23420'),

('2016-09-16 00:00:00.000', 'Schema', 'dbo'),

('2016-09-16 00:00:00.000', 'Table', 'Endorsement'),

('2016-09-16 00:00:00.000', 'Index', 'IdxAssociationId')

) x ([Date], [Type], [Value]);

SELECT

[Schema] = MIN(CASE WHEN t.Type = 'Schema' THEN t.Value END),

[Table] = MIN(CASE WHEN t.Type = 'Table' THEN t.Value END),

[Index] = MIN(CASE WHEN t.Type = 'Index' THEN t.Value END),

[fragmentation] = MIN(CASE WHEN t.Type = 'fragmentation' THEN t.Value END),

[page_count] = MIN(CASE WHEN t.Type = 'page_count' THEN t.Value END)

FROM

#temp t;

Results...

Schema Table Index fragmentation page_count

---------------- ---------------- ---------------- ---------------- ----------------

dbo Employer EmployerIdx 43.851409052 23420