assuming I have the following table with sample data (ID is a GROUPBY and list is a GROUPCONCAT of another sheet):
ID | list
1 | [a,b,c,c,b,a]
2 | [a,a,a,c,d,b,a]
What I want to do now is remove all pairs with the same elements so that
[a,b,c,c,b,a] becomes [a,b,c,b,a] and
[a,a,a,c,d,b,a] becomes [a,c,d,b,a]
How can I achieve this? GROUPCONCATDISCTINCT is not an option since it would remove every reoccuring points it the list.
Thanks in advance and with best regards
Please sign in to leave a comment.