I joined two tables to a shapefile and the output table has a field from each. Both fields represent the same thing so I'd like to combine them into one. You can see a clip of my fields below, where most of nulls are populated in the adjacent field.
Simply enough, I just want the final output to read as (based on the fields above)
<null> Complete Verified Verified Verified Verified Construction Construction Construction <null> Verified Approved Complete Verified <null> Complete etc
I was thinking about using field calculator to say "If field 1 is None, field 1 = field 2" but that either doesn't work or I was getting the syntax wrong. Also, I have a few sets of three fields that I need to merge so that wouldn't work for that unless I calculated twice?