How to Concatenate Data from Different Rows into One in BigQuery

I want to concatenate my data from a particular column which is present in different rows.

The Data is something like this:

I want the output as Jack, John, Julie. Every name should be unique.

I tried using string_agg(distinct Name), but the result is coming out as (Jack, John, John, John, Julie, Jack, Jack, Julie).

How can I solve this issue and get the desired result?

Use below

select string_agg(distinct trim(nm), ', ') as names
from your_table, unnest(split(name)) nm  

if applied to sample data in your question - output is