I think similar questions have been asked before but I am still a bit confused.
The image attached shows how my data looks like. However, I would like to replace whenever "N/A" appears in Sample_Location with the corresponding value in Sample_Address. the expected result is attached below
Appreciate if someone could help out please.
thanks