Created:
Oct 23, 2012 10:21 AM
| Last Modified: Oct 23, 2012 7:21 AM(11292 views)
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.
Created:
Oct 23, 2012 10:34 AM
| Last Modified: Oct 23, 2012 7:34 AM(10876 views)
| Posted in reply to message from hacketkm 10-23-2012
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.