I have a file which looks like this
I would like to print the duplicate values in column only once and their corresponding values converted to tab delimited. So I am expecting my results to look like this
Con1 BC1:10 BC2:2
Con2 BC1:80 BC2:40
Con4 BC1:1 BC2:12
Any ideas of how to get this using awk/sed/perl ?
Thanks in advance,