Jul-08-2018, 08:04 PM
Hi all,
From this input:
google.com, hello, blublu
google.com, hello, blabla
google.com, nothello, bleble
facebook.com, hi, blabla
facebook.com, hey, bleble
how can i generate this output:
google.com | hello, hello, nothello | blublu, blabla, bleble
facebook.com | hi, hey | blabla, bleble
It's important to not delete same values (i.e. "hello, hello" in the second column of the output must remains because each input's rows is an identificative and when i see the output i would understand from which input come from).
How could i do that?
Thanks
Alex
From this input:
google.com, hello, blublu
google.com, hello, blabla
google.com, nothello, bleble
facebook.com, hi, blabla
facebook.com, hey, bleble
how can i generate this output:
google.com | hello, hello, nothello | blublu, blabla, bleble
facebook.com | hi, hey | blabla, bleble
It's important to not delete same values (i.e. "hello, hello" in the second column of the output must remains because each input's rows is an identificative and when i see the output i would understand from which input come from).
How could i do that?
Thanks
Alex