URGENT - Combining Values In 2 Columns

[imcdonaghw]

Morning everyone,

Needing urgent help for a report I'm doing in work this morning.

I have two lists/columns with text values (e.g. countries) and I'm wanting to combine these into one list which has both columns values.
The problem is that not every name in List 1 is in List 2 and vice versa.

Example
Col 1 Col 2
Scotland Canada
England Brazil
Wales N. Ireland
Scotland

I'm wanting to create a full list on unique values/countries (I'll be doing a vlookup after this to get their summed values, which I know how to do)
I'm needing help coming up with a solution to create a list but not duplicate any values.

Anyone got any ideas please?

Thanks
Iain

[xlnitwit]

Hi,

A simple method is to copy one list below the other, then use Advanced Filter, checking the Unique option, to filter the combined list to a new location as a unique list.

[imcdonaghw]

Doh, I'm trying to make it lot more complicated than it should be hehe.

Thank you Don for replying so quickly, it's very much appreciated.