You could copy the contents of the two source columns into a single column,
then use either the AutoFilter or Advanced Filter method to remove the
duplicates.

These are found under Data / Filter on the worksheet menu bar, and you
should note that the range to be filtered needs to have a header row at the
top.

Hope that helps,

TK

" wrote:

I have two worksheets.

Each have a Primary Agency column,

I would like a third worksheet that consildates the two worksheets to
one column of unique values.


Example:

Worksheet 1
KT
A5
12
12
KT
JK

Worksheet 2
GT
KT
A5
14

Worksheet 3 (the worksheet I want to generate) should look like:

KT
A5
12
GT
14
JK

Notice that they are combined but also only listed once.

Thanks In Advance.