Hi @pantelis,
Based on your question, it sounds like you are trying to use a listagg function, which is currently not possible with the UI. However, I would definitely look into this talking about the new data prep experience and the following picture below showcasing aggregation capability:
Hope this helps and let me know if you have any questions!