I am struggling to convert some values into other values, depending on what's happened in preceding columns.
In the example below, I want to convert any instances of double letters (AA, CC, GG, TT) into either AA or BB. However, the problem is that I want the determinant of whether it's AA or...