Hi All,

I need help with a vba script.
I have two lists, a couple of columns apart. The columns contain, and must contain, blank spaces. The number of rows in each of these columns varies.

I need to be able to extract unique values from each of these, and combine them into one column.

I have found other scrips online which kind of do the trick but:
1. Break when the range selected goes pass the last cell with values
2. Are assigned to two different buttons on the same sheet (I tried using one script and one button per column, and then combine)
3. Can, seemingly at random, produce a list of unique values with a bunch of blank spaces in random places.

Any ideas?