collating 3 columns into one without redundancy

K

Kashgarinn

Hi there.

I've got 3 columns of names of domains, which are never the same, and
want to create a list (or column) which takes these 3 columns and list
the domains in order without redundancy (the same name could be up t
10 times, so that name should appear only once in the list)

I've no idea how to do this, can anyone help?

Regards,
K
 
D

Dave Peterson

I'd put all 3 columns of data into one column.

Then use Data|Filter|Advanced filter (unique records only).

Debra Dalgleish has some instructions at:
http://www.contextures.com/xladvfilter01.html#FilterUR

If the list is too large to combine into one column, then I'd use that same
technique 4 times--eliminate the duplicates from each of the 3 columns, then
combined those three lists. And run it one more time.
 
K

Kashgarinn

Actually I can't put them into one column, unless you know how to mould
three columns into one via microsoft query? Because that's why there
are three.. and to make 100% sure that I find all the domain names
(there are three columns, one called "username", one called
"old.username" and one called "description") and as it's a microsoft
query I can't just put the columns together..

Any ideas?

K.
 
Top