Sorry, my title might not make sense but I want to combine some columns where there are null values. For example, in column one, row two should read ‘United States’ etc

Thanks,

the query is so far only a select on different columns from different linked servers