A | B | C | |
---|---|---|---|
1 | original list | Smith, Miller, Patty, Smith, Patty, Miller | |
2 | reduced list | Smith, Miller, Patty | |
3 | formula | =JOIN(", ",UNIQUE(TRANSPOSE(SPLIT($C$1,", ")))) | |
4 | |||
5 | sorted list | Miller, Patty, Smith | |
6 | formula | =JOIN(", ",SORT(UNIQUE(TRANSPOSE(SPLIT($C$1,", "))))) |