Basically I am focusing on 2 fields. fields[0] = Apple fields[1] = Grape fields[2] = Pear What I want in English: If Apple has data and Pear has no data Pear = Apple If Grape has data and Pear has no data Pear = Grape Otherwise: Pear = Pear *All 3 columns will never be populated, as well as Apple and Grape will never be populated simultaneously I tried making up a script using Notepad ++ but it is not translating at all and the results are just reading the columns as their original data. I know this is wrong but I do not know what would be right. Thanks
... View more