Forum Discussion
merging two columns with overlapping data
Is there a simple way to merge the first and second column so that only one column of unique values are presented? Hopefully the picture will show what I am referring to. Column A and B have a lot of...
I do not understand the question. Column B is a unique list of all the values in the dataset comprising columns A and B. Were it not, the 365 formula would return such
= UNIQUE(TOCOL(data, 1))
Maybe the second picture will explain it a little better. I don't know why at the end of the table there are a bunch of out of sequence zip codes and values that aren't in Column B.