I am going to assume you are using DataFlow for the Import.
The easiest way is to go into the Advanced Editor and add a step to do a Transform on the data with whatever delimiter is used in your list. It is usually either a , or a ;
To do this you will want to add a column with a new name that includes the Transformed data.
"Added <VariableName>" = Table.AddColumn(Navigation, "<Column Name That You Are Adding", each Text.Combine(List.Transform([<Original Column Name>], each Text.From(_)), "<Your Delimiter>"))
Once you have added the new column you will have to make sure to add it to your result set so that it contains the data.
Thanks
38
