singlecellextract in power bi

[KL718]

Hi, Below is the data. I want output as mention in Green column. I found there is a way of doing it with Edit Query option. Using Group by & need to write power query. But I want output as per below.

[v-chuncz-msft · Accepted solution]

@KL718 ,

Add a calculated column in DAX.

Column =
CONCATENATEX (
    FILTER ( Table1, Table1[Name] = EARLIER ( Table1[Name] ) ),
    Table1[Exp],
    UNICHAR ( 32 )
)

[KL718]

Thanks a lot!