Hi All,
I was trying for this for a long time,How to get the union of 2 cells in the cell. For example if cell A:A contains 1,2,3,4,5 and cell B:B contains 3;4;5;6;7;8 my cell C:C should contain C = A Union B. Look at the below example for how i want the results should be. I am trying to achieve in some formula.

A B C
1 3 1
2 4 2
3 5 3
4 6 4
5 7 5
8 6
7
8