Select ProcedureId, [3_1_explain_alert_system_and_boosters_required], [1_1_patient_blacklist_checked]
FROM
(
select ProcedureId, HtmlValue, TokenValue from ProcedureStepsDetails
) As Temp
PIVOT
(
max([HtmlValue])
FOR [TokenValue] In([3_1_explain_alert_system_and_boosters_required], [1_1_patient_blacklist_checked])
) As pt