Forum Discussion
Solved
Changing text column into specific numbers.
Hello I am trying to make a key from 2 columns of responses. The results are either Happy, Neutral, or Unhappy and there are only two columns with those responses. I want to make a new column th...
I ended up creating 6 columns for each value i.e. one for the 1st outcome happy, one for the 2nd outcome happy etc and then adding those together to get my total column.
I feel like there has to be a more efficient way but that was all I could come up with.
Thank anyone for any insight.
I ended up creating 6 columns for each value i.e. one for the 1st outcome happy, one for the 2nd outcome happy etc and then adding those together to get my total column.
I feel like there has to be a more efficient way but that was all I could come up with.
Thank anyone for any insight.