Mering columns

[mewmew18102]

What I want is to merge column "F42" with column "F40". As you can see how there is 3 '0' in column F40, the 3 numbers (12.47,8.49,41.95) on column F42 are suppose to be in F40 where the '0' are. How do I do that?

[flying008]

Hi, @mewmew18102 

[F40] = IIF([F40] = 0 , [F42], [F40])

[alex]

Based on the column names you are showing I have another suggestion.  You may want to inspect your data in case everything for those 3 rows is shifted 2 columns to the right.  This can happen when bringing in text files and they are not lined up properly or have an extra delimiter.  If you used the Union tool same thing could happen if you selected Auto Config by position and the merged data was not in the same order.