| Name | Gender |
|---|---|
| Aurelia;Camila;Aurelia;Camila | Female;Female;Female;Female |
I want to remove the duplicates in these columns.
I using this formula: value.split(";").uniques().join(", ") and return me this:
| Name | Gender |
|---|---|
| Aurelia,Camila | Female |
But i want to return:
| Name | header 2 |
|---|---|
| Aurelia,Camila | Female, Female |