Forum Discussion
KrisSok
2 years agoNew Member
Splitting multiple columns by delimiter into multiple matched rows
Hi I have a large spreadsheet with 5 columns which can have multiple values (up to 200) separated by commas: Status Platform Exit Date INSIDE 25 PSERIES 19/04/2024 NO TREATMENT,NO T...
- 2 years ago
In the NewTbl row, you can specify the column names. I have specified only Status and Exit Date.
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], NewTbl = Table.SelectColumns(Source, {"Status", "Exit Date"}), Custom1 = Table.FromColumns(List.Transform(Table.ToColumns(NewTbl), (x)=> List.Combine(List.Transform(x, (y)=>List.ReplaceValue(Text.Split(y, ","),"",null,Replacer.ReplaceValue)))), Table.ColumnNames(NewTbl)) in Custom1
KrisSok
2 years agoNew Member
thanks for your help 🙂