I would like to combine two columns into one. My data looks like the table below where "." represents missing data. I would like to make a column which resembles Column C.
|Column A||Column B|
So far I have tried adding a new column with the formula: If( :Column A != "", :Column A, :Column B) but this doesn't work and I'm not sure why. It fills in the values from Column A but not from Column B.