How are you all? Thanks in advanced for all answers and support I´m receiving so far, I really appreciate it. For my nesxt task:

Current table:

CodePudding user response：

Use below

select id, format('%t', array_agg(protoc) over()) protoc
from your_table      

if applied to sample data in your question - output is