Transform list into comma-separated text.

[tall27]

Hi,

My json file allows multivalue in the field, that result in different results in the table. 

after the import, I can see 'lists' and  the values (for a single value).

I struggle to expand all lists, and show all channels in the same cell

is it possible to achieve ?

Thank you ahead!

[AlienSx · Accepted solution]

Hi, @tall27 

Table.TransformColumns(source_table, {"column_name", (x) => if Value.Type(x) = type list then Text.Combine(List.Transform(x, Text.From), ", ") else x})