My Input was this :
Cons_id prof Rank
183580 JAVA 2
183584 JAVA 3
183589 JAVA 12
183552 JAVA 3
183570 JAVA 16
183574 JAVA 1
183587 JAVA 1
183580 PHP 3
183584 PHP 3
183570 PHP 17
183580 .net 6
183552 .net 1
183570 .net 64
183587 .net 4
I want to covert result in to this form'
Cons_id Profile
183580 JAVA-2,php-3,.net-6
183584 JAVA-3,php-3
183589 JAVA-12,
183552 JAVA-3,.net-1
183570 JAVA-16,php-17,.net-64
183574 JAVA-1,
183587 JAVA-1,.net-87
I want to convert in this form like my id was 183580 we found three result of this id java php and ,net i want to convert in to , seperated results for particualr rank of this id.
What I have tried:
I want to convert in this form like my id was 183580 we found three result of this id java php and ,net i want to convert in to , seperated results for particualr rank of this id.