Respondents to a survey (rows) will give a colour as an answer in one of four columns. The other three columns have the value “none”. I am trying to create a new column that picks up the colour that’s in one of those columns