Fill column with values based on another column with keys and associative array
I did a quick search and couldn't find a solution. I solved it in a pretty complex way some time ago, but was wondering if there is an easier way.Problem: I have an associative array of a form:assarr = ["AA" => "AAA", "BB" => "BBB", => "CCC" ];
I have a column "A" that has either "AA", "BB", or something else.I need to fill column "B" with values based on the associative array and column "A". i.e. ...