Want comma seperated value just below (in next line) of earlier one but in the same cell.

[jay_patel]

Hello All,

Is it possible to get CSV in same cell but in next line.

Ex:

1) 250 mg, 2) 500 mg

to 

1) 250 mg
2) 500 mg

Thanks In Advance.

[amitchandak]

@jay_patel , Power query split by delimiter into rows https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

[jay_patel]

Hi @amitchandak 

I refered above mentioned link by you, but still unable to find solution for the same.
Required : CSV into new line but in same cell, it is possible to replace comma with enter?
  

[amitchandak]

@jay_patel , a little different approach than use power query replace,

Create replace with #(cr) , and make sure it looks like below
or replace that once you get the code

Table.ReplaceValue(#"Changed Type",",","#(cr)",Replacer.ReplaceText,{"Column1"})

.

full Table code

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtRUMDI1UMhN11Ew0lQwNQAxlXSUlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type",",","#(cr)",Replacer.ReplaceText,{"Column1"})
in
    #"Replaced Value"