HI EVERYBODY
Here is the problem:
I have MULTIPLE and SEPARATEd columns each contains hundreds of data some thing like:

column A
egg
bread
apple
milk
butter

column c
bread
milk
jam

column e
apple
orange
banana

and i need to create column that represents ALL that data WITHOUT duplicates

i.e like this:

column g
egg
bread
apple
milk
butter
jam
orange
banana
is that possible using an excel formula? honestly, i know very very little about vba...
is it possible to make the last column (g) dynamic? i mean to refersh automatically when adding data to the source columns (a, c and e)?
thanks a lot!