How to consolidate columns into comma-separated lists?

[bikelley]

Hello

I am trying to consolidate the Case numbers into a comma-separated list. So I have one UID instead of duplicating it. Case Number Column coming from expanding column from merge table. Can anybody please tell me how do I achieve the below result? 

Now 

What I want 

Thank you so much 

[bikelley]

@amitchandak  This works for me. Thank you so much for the help. 

[amitchandak · Accepted solution]

@bikelley , if you only want in display then 

measure = concatenatex(Table,Table[Case Number])

Display with ID in visual

or try this in power query

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKjRU0lEyNDJWitWBckxMzRAcUzNzCMcIyDEzReKYm1koxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Number = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", type text}, {"Number", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"ID"}, {{"Count", each Text.Combine([Number] , ", "), type nullable text}})
in
    #"Grouped Rows"