I have an excel file with two columns of data. I would like to Combine data
from the two columns into one column with no duplicate values. Each column
contains unique values, but some are duplicated between columns.

I know I can use the concatenate function but I cant figure out how to get
rid of the duplicate data between columns. I tried the advanced filter but
that looks at the data from each column individually and not between columns.

Thanks,