Drawing a blank on this one. I have multiple columns of survey responses, where respondents can choose any of the following;
Level 1 - Strongly disagree
Level 3 - Neither agree nor disagree
Level 5 - Strongly agree
For any options throughout the entire survey that have "Level 1 - Strongly disagree", i would like to assign this a value of 1, and so on for the other options, up to a max score of 5.
I tried using the find and replace tool, and the dynamic replace tool, but I'm still having trouble. Goal would be to only have numeric values between 1 and 5 for all responses across all questions.