I have a dataset which looks like below. i want to create a new column that will show the type of pathway applicable for each row. For example, if Pathway_English is 1 only, then the new field (let's call it Pathway_Type) will show "English". If both Pathway_English and Pathway_Diploma have values as 1, then the Pathway_Type will be "English_Diploma". If all three are populated, then the new field will be equal to English_Diploma_Foundation. If all are 0, then the new field will be "No Pathway". Can anyone suggest a solution?
