Replace null value with the value in the next column

[arsalanzaki]

I am trying to replace the null values in the column "Extracted_Telstra_Site_ID" with the values in the next column "Extracted_Telstra_Site_ID_2", please see the image attached.

[ShankerV · Accepted solution]

Hi @arsalanzaki 

Step 1: Formula tool

IF IsNull([Extracted_Telstra_site_ID])
THEN [Extracted_Telstra_site_ID_2]
ELSE [Extracted_Telstra_site_ID]
ENDIF

Many thanks

Shanker V

[arsalanzaki]

Thanks, it worked.