Excel. Merge columns and remove duplicates
<p>Having Column A - H with data that might or might not be duplicated in each column, I would like to get data from the columns merged into one column with removed duplicates.</p>

<p>Is this possible with FORMULA or do one need macro/vba?</p>

<p>I would prefer formula since the later is not my force (neither the first ;-))</p>