Here is the approach I would take:
1. Create a Calculated field that replaced the NULL values with values from the other column. The code would be something like:
IFNULL([Sls Rep Name], [Major Cust Name])
2. Remove the original Sls Rep Name column
3. Rename the new calculated field to match the original name Sls Rep Name
Hope that helps!
Thanks so much Joshua! I was trying to isolate the exceptions and that was my error. Great simple solution.
You're welcome Dru! Glad it helped!
In case if we have an integer column can we replace it with something as median or mean or mode or last occurring value