Merge 2 columns into one with unique values

Hi
The people on this site have been very helpful to me in the past, all of which I appreciate very much, so I am hoping someone can help me again.

I have 2 columns of text, Column 1 A3:A50 & Column 2 B3:B50
I would like to create 1 column of unique values in Column 3 A3:A??

I have tried the function Unique(A3:B50) but the 2 columns stay separated, I need them in one list.

If possible I would like to ignore blanks and if more is added to column 1 or 2 then column 3 would auto update.

Fingers crossed

Thank you in advance

It would be as if Column 1 and Column 2 were one column and column 3 would have the unique values without any duplications
There are some values in col 1 that are also in col 2

How about

Formula:

Please Login or Register  to view this content.

The formula works fantastic but one thing I didn't foresee,
each of the cells in the list has 2 more cells on the same row with info about the item in the list.
If i add another item and it adds to the auto list it puts the info out of sequence.

I hate to ask again but is there a way that if a new item is added,
when it appears in the auto list can it be possible that it either
1) puts it on a new row at the bottom of the list
OR
2) creates a new row for the new item

The info about each item is added manually.

I have attached a file
Column A is not relevant to this problem it just needs to be there for my benefit.
Column B & C are the types that I need in a unique list
Column E is the unique list generated by the formula from Fluff13
Column F & G is info relating to the item in column E

If I insert a new staple type in column B or C then the type (If unique) is added to column E
Unfortunately it puts the data in Column F & G out of sync.
If possible can the new staple type that is added go to the bottom of the existing list (this would be preferable) so that the info can be added manually.
OR when the new type is added in column B or C and is created in Column E can it create a new row for itself.

I realise that using the second suggestion would create a row in columns A-C as well but I can move the list below everything else so it wont matter.

Sorry if this is a bit long winded.

Hopefully you understand my gibberish and can help.

Thank You

The 2nd option is not possible, as a formula cannot insert rows.
Unfortunately the 1st option is not possible either (or at least I have no idea how to do it). The formula is simply getting all the data from col C & stacking below col B & then removes blanks & duplicates.
However if you create a lookup table with the data in F & G, you could then use a formula to pull that info in.