I need to get a CXXXXX code into column A for every line that I have in my data table. Some of the rows already have the code in column A. In other rows accross columns B - F I have 1 of 2 possibilities:
(a) the CXXXXX code in column D, and/or
(b) a transaction code in columns B or F...