Hi,

If say I have 3 lists of data (1 in column A, 1 in B and 1 in C), is there a
way that I can get Column D to produce a list of all the unique values from
A,B,C.

IE:

Col A Col B Col C....... Therefore Col D =
a t z a
b q w b
c a a c
t
q
z
w

TIA.