collating 3 columns into one without redundancy

[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

 

[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.

 

[Guest]

If this is something you have to do regularly, I would suggest using Jim
Cone's fine commercial Add-in called XL Companion. It's available at
http://www.realezsites.com/bus/primitivesoftware/

Just copy and paste all the three columns into one, and use XL Companion to
extract the uniquerows.

hth
Vaya con Dios,
Chuck, CABGx3

 

[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.