Forum Discussion
Coby
3 years agoNew Member
How to prepare multiple rows with two different colums
Hy, I would kindly ask your help. I have a table with many columns from SQL database. This database contain one colum which contain two ore more ID spearated with " ; " (semicolons). I can split co...
wdx223_Daniel
Community Champion
3 years ago=#table(Table.ColumnNames(OriginalTable),List.TransformMany(Table.ToRows(OriginalTable),each Text.Split(_{0},";"),(x,y)=>{y}&List.Skip(x)))