B
bdaoust
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.
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.