Forum Discussion
split columns with null result
hi, i am trying to split the column "transact" into 02 columns(first picture). but each time i try i got null result on the second column. is there something wrong that i am doing ? let
...
I guess this formula can help you, Otherwise please provide your smple data as table here to provide the solution based on your data
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Split Column by Delimiter" = Table.SplitColumn(Source, "transact", Splitter.SplitTextByDelimiter("#(lf)#(lf)", QuoteStyle.Csv), 2)
in
#"Split Column by Delimiter"thank you, but your solution give the same output that i got .
Please provide the sample file or sample data as table here
i tried to upload excel file, but couldnt find an option for it ....sorry
i tried to upload excel file, but couldnt find an option for it ....sorry
