, max(case when column_name = 'DIAGNOSIS_POA_1' then normalized_code else null end) as diagnosis_poa_1 , max(case when column_name = 'DIAGNOSIS_POA_2' then normalized ...