how to replace blanks with values from another column
Hi All, I am trying to populate blank cell with a value from another column, i.e. if 'country' is blank then populate with a value from 'country_1' I tried the below, but it doesn't seem to work. CASE WHEN LENGTH(`Country`)=0 THEN `Country_1` END Please help! Thanks Max
