select distinct tp.[order],tp.Module,
(case tpt.Name when 'Color' then Value else '' end) Color,
(case tpt.Name when 'Total' then Value else '' end) Total,
(case tpt.Name when 'DeliveryDate' then Value else '' end) DeliveryDate 
from UserDataModel.T_LeanLinePlan tp left join
UserDataModel.T_LeanLinePlanAttribute tpt
on tp.LeanLinePlanId=tpt.LeanLinePlanId

select tp.[order],tp.Module,
Max(case tpt.Name when 'Color' then Value else '' end) Color,
Max(case tpt.Name when 'Total' then Value else '' end) Total,
Max(case tpt.Name when 'DeliveryDate' then Value else '' end) DeliveryDate 
from UserDataModel.T_LeanLinePlan tp left join
UserDataModel.T_LeanLinePlanAttribute tpt
on tp.LeanLinePlanId=tpt.LeanLinePlanId
Where Name in('Color','Total','DeliveryDate')
Group by tp.[order],tp.Module