Hi all,

I have this exel file with two columns A (ID) and B (Gene):
ID             Gene

hsa-let-7a	KRAS
hsa-let-7a	HMGA2
hsa-let-7a	integrin beta(3)
hsa-let-7a	caspase-3
hsa-let-7a	PRDM1/Blimp-1
hsa-let-7a	HMGA2
hsa-let-7a	IGF-II
hsa-let-7a	HMGA2
hsa-let-7a	HMGA2
hsa-let-7a	RAS
hsa-let-7a	BCL2
hsa-let-7a	RAS
hsa-let-7a	MYC
hsa-let-7a	CDC25A
hsa-let-7a	CDK6
hsa-let-7a	NF2
hsa-let-7a	c-myc
hsa-let-7a	RAS
hsa-let-7a	RAS
hsa-let-7a	NIRF
hsa-let-7b	Cdc34
hsa-let-7b	Dicer
hsa-let-7b	KRAS
hsa-let-7b	CCND1
hsa-let-7b	CDC25A
hsa-let-7b	CDK6
hsa-let-7b	HMGA2
hsa-let-7c	HMGA2
hsa-let-7c	HMGA2
hsa-let-7c	HMGA2
hsa-let-7c	BCL2
hsa-let-7c	RAS
hsa-let-7c	CDC25A
hsa-let-7c	CDK6
hsa-let-7c	RAS
hsa-let-7d	KRAS
hsa-let-7d	HMGA2
hsa-let-7d	BCL2
hsa-let-7d	RAS
hsa-let-7d	CDC25A
hsa-let-7d	CDK6
hsa-let-7d 	BDNF
hsa-let-7d 	D3R
hsa-let-7e	HMGA2
hsa-let-7g	KRAS
hsa-let-7g	HMGA2
hsa-let-7g	Ras
hsa-let-7g	HMGA2
hsa-let-7g	CDC25A
hsa-let-7g	CDK6
hsa-miR-1	c-Met
hsa-miR-1	calmodulin
hsa-miR-1	Gata4
hsa-miR-1	Mef2a
hsa-miR-1	BCL2
hsa-miR-1	Gata4
hsa-miR-1	calmodulin
hsa-miR-1	Mef2a
hsa-miR-1	C/EBPa
hsa-miR-1	FoxP1
hsa-miR-1	HDAC4
hsa-miR-1	MET
hsa-miR-1	HCN4
hsa-miR-1	FoxP1
hsa-miR-1	HDAC4
hsa-miR-1	MET
hsa-miR-1	Cdk9
hsa-miR-1	fibronectin
hsa-miR-1	RasGAP
hsa-miR-1	Rheb
hsa-miR-1	MEF-2
hsa-miR-1	nAChR
hsa-miR-1	GAJ1
hsa-miR-1	KCNJ2
hsa-miR-1	HSP60
hsa-miR-1	HSP70
hsa-miR-1	Hand2
hsa-miR-1	Kir2.1
hsa-miR-100	Plk1
......
(line cut)
I would like to have for column A a single entry and in column B the respective associated name comma separated, like that:

ID                     Gene
  
hsa-let-7a    KRAS,HMGA2,integrin beta(3),caspase-3,PRDM1/Blimp-1,HMGA2,IGF-II,HMGA2,HMGA2,RAS,BCL2,RAS,MYC,CDC25A,CDK6,NF2,c-myc,RAS,RAS,NIRF
hsa-let-7b    Cdc34,Dicer,KRAS,CCND1,CDC25A,CDK6,HMGA2
hsa-let-7c    HMGA2,HMGA2,HMGA2,BCL2,RAS,CDC25A,CDK6,RAS
.........
Do you know any way to do that automatically?

Thanks in advance,
Giorgio