How to change the list of column value to the horizonal view with ","

[naoyixue1]

Hey all,

I'm working on something, in which I have to convert the value in the column to the horizontal view, and each SKU will be split with ',' (RHS). Not sure we can do so in power query.  Do you have any thoughts? Thanks!

[Anonymous · Accepted solution]

Hi @naoyixue1,

You can try to use the CONCATENATEX function to convert table field list to a text string.

formula =
CONCATENATEX ( ALLSELECTED ( 'Table' ), [Column], "," )

Regards,

Xiaoxin Sheng

[naoyixue1]

@Anonymous It works. thank you so much!

[naoyixue1]

Any thoughts? Thanks all!