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))