Forum Discussion
Split Text Up and Down
Hi Chanleakna123,
You can use Split Column by Delimiter feature with line break #(lf). You can test with below Power Query:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8s5IzFNwSSzNUwhIzctQMDQyMjBQiMkLKE4sUgjJTc1UMAaJGRooxepAFTtnJOZmJxbl5hflAaWMDQxi8kLyS3MUgssSKxUCilIrDcHCFkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.Csv), {"Column1.1", "Column1.2"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1.1", type text}, {"Column1.2", type text}})
in
#"Changed Type1"
Reference:
https://www.excelguru.ca/blog/2015/10/16/split-by-line-breaks/
Best Regards,
Qiuyun Yu
See the 3 pictures i shared ,
and the other one with the table of the line up and down.
i failed to success your.
can you please advise more.
Hi Chanleakna123,
Is the issue solved? If it is, please mark a helpful reply as an answer.
Best Regards,
Qiuyun YuHi ,
i'm sorry , i can't accept this solution , due to i use multiple files , few files are worked but few are not .
i just get back to the issued file .
below is BI File i shared.
Even i try with #(If ) , #(cr) , it doesn't work. Just wanna understand how to acheive this ?
https://drive.google.com/file/d/1wc8cjIIhUpmE1-zeJARDCLWxAjWK0Irz/view?usp=sharing
here it is
