What inspired this wish list request? This is a feature I use all the time in Excel when I need to apply a constant transformation to a set of values
What is the improvement you would like to see? Please consider adding an option under the red triangle menu in the Recode utility for transforming numeric values. Perhaps I need to multiply or divide a few values by 100 because some people input a percent as 0.1 and others as 10. Currently I have to change each of those values one by one but this is very easy to do in Excel as shown by the attached screenshot.
Why is this idea important? Recode is an amazing utility but this seems like a minor gap in its functionality compared to Excel. There aren't many options for recoding numeric column so this would be helpful. The quick New Formula Column options are great for when you need to transform an entire column but often I only need to do this for a few values.
