I have a point feature that I want the closest address for, I have done this by a spatial join on the closest known address point.
However, I have the address now for each point but because of the way the address point feature that I used for the spatial join was set out the address could appear in 1 of 2 columns (see screenshot)
Is there a simple way I can just bring all the addresses into 1 new column from the 2 address columns, so I have a list of addresses for each point?
At the moment the addresses are scattered between 2 columns which makes it very hard to work with.
(I marked out in red the addresses for privacy reasons)