Is there way to use text to column and then have all the same data go to same column?
ex. In a1, mom,dad,son,last name
In b1 son, mom, last name
C1 mom, last name.
D1, mom,son,dad,brother, sister,aunt,last name.
How do I get all the unique values into the same column?