I have several lists with two fields - first field contain an URL, 2nd field an email-address (an account). The 2nd field is the same for all entries in a list.
I concatenate the lists to one list, and sort it by the 1st field. Most entries are unique, but some are duplicates or triplicates (ie. the URL was in the list for multiple accounts).
Is there a command or script that I can use to join the duplicates, so the 2nd field became a list of accounts when required?
For example: url1 acct2 url2 acct1 url3 acct1 url3 acct2 url4 acct2 url4 acct3 url4 acct5 ... Should become: url1 acct2 url2 acct1 url3 acct1 acct2 url4 acct2 acct3 acct5 ...