Group list into one cell

[ludovic_ott]

Hello,

I am trying to change the table below :

To look like this:

Material	Work Ctr
9266802471	TBD24 TBE22 TBE24

Basically have all "Work Ctr" for the material 9266802471 listed into one cell with one space between each. How can I do this ?

Regards

[v-yiruan-msft · Accepted solution]

Hi @ludovic_ott ,

You can create a calculated column as below to get it:

Column = 
CONCATENATEX (
    FILTER ( 'Table', 'Table'[Material] = EARLIER ( 'Table'[Material] ) ),
    'Table'[Work Ctr],
    " ",
    'Table'[Work Ctr], ASC
)

Best Regards

[lbendlin]

read about CONCATENATEX  in DAX, or Text.Combine in Power Query