I would like to vertically cosolidate data from Column A and Column B into
Column C, excluding duplicate data. Suggestions? Thanks!

Example:
A B C
1 AAA AAA AAA
2 BBB EEE BBB
3 CCC FFF CCC
4 EEE
5 FFF
6