Forum Discussion
Split column
Hi, I am hoping to split a single column into multiple, having a column for each licence type. Thanks in advance Single Column: Result Columns from above single column: Office 356 Enter...
NewStep=Table.Combine(Table.ToList(PreviousStepName,each let a=Text.Split(_{1},",") in #table({"Email Address"}&a,{{_{0}}&List.Repeat({"Yes"},List.Count(a))}))