From the above table, I want to get the Patient ID’s which is having the Treatment Column Value “yes”, along with the column name. I want to get the patient ID, which doesn’t have a single yes i.e Need to get the Patient ID if all the values are “No”. Can anyone help me on this.