Código SQL [-]SELECT IDMuestra, max(case when IDLab = 1 then TenorAu else 0 end ) as Lab1, max(case when IDLab = 2 then TenorAu else 0 end ) as Lab2, max(case when IDLab = 3 then TenorAu else 0 end ) as Lab3 FROM Muestras_Analizadas GROUP BY [IDMuestra]
SELECT IDMuestra, max(case when IDLab = 1 then TenorAu else 0 end ) as Lab1, max(case when IDLab = 2 then TenorAu else 0 end ) as Lab2, max(case when IDLab = 3 then TenorAu else 0 end ) as Lab3 FROM Muestras_Analizadas GROUP BY [IDMuestra]