I have two columns, A on one sheet, B on another. I want to return a third column which is the unique values that appear in these columns. Something like =UNIQUE(A:A,B:B) doesn't quite work. W...
Chris2215 You can build a powerquery on the first table, save to model, build another one on the 2nd, use combine/append, then right-click the column to remove duplicates.
