How to nest values in a list from multiple rows in dremio

I am trying to create a list of products carried by customers.

I want to convert

|Cust Nbr|Products|


|Cust Nbr|Product|
|12345|ABC, BCD, CEF|

Any ideas?


Currently, there is no single function that Dremio offers to achieve your end result

Any way to create a custom function?


Yes, you can create a UDF and use it

Here is an example GitHub - jacques-n/dremio-udf-example