Merge GeneIDs in table

[cascoamarillo]

Hi,
I am not able to find a solution here. Maybe someone can chime in. The task seems simple: A table with GeneIDs in one colunm and GOs in another. the problem is that I have 1 Gene - 1 GO per row. I would like to merge those from the same ID and place all GOs in the second column. Something like:

g00010 GO:1903046
g00010 GO:1990391
g00020 GO:0000003
g00020 GO:0000075
g00020 GO:0000076​

and output:

g00010 GO:1903046,GO:1990391
g00020 GO:0000003,GO:0000075,GO:0000076

So it can be input into run_GOseq.pl

TIA

[cascoamarillo]

After a few prompts whith ChatGPT it looks like a find a solution:

awk '{ arr[$1] = arr[$1] ? arr[$1] "," $2 : $2 } END { for (id in arr) { print id, arr[id] } }' input.txt​