Conditional Column - Survey Ratings

Hi Hotchilli,

Thanks for the advice and solutions. I'm a beginner user here so appreciate if you can give further clarity here.

The first solution seems easier but I do not know how to change the logic to test all 3 columns so I tried the second solution i.e. split the logic to add 3 conditional columns(Response ID(1), (2) and (3)) but not sure what to test for the 4th conditional column. If I use if Response ID(1) equals Agree/Strongly Agree then Agree/Strongly Agree followed by else if Response ID(2) equals Agree/Strongly Agree, else if Response ID(3) equals Agree/Strongly Agree then Agree/Strongly Agree, else Others, then as long as one of the columns contains Agree/Strongly Agree, even if the others contain Others, it wil somehow wrongly classify it as Agree/Strongly Agree and I would be back to the initial problem(see below screenshot). Hope you can further enlighten me, thank you so much!