Forum Discussion
Split a single row into multiple rows based on multiple columns
Hi, I new to Power BI and new to this board. I have an incoming table like this: PIDM College 1 Dept 1 College2 Dept2 1 VP ...
=#table({"PIDM","College","VP"},List.TransformMany(Table.ToRows(YourTable),each List.Split(List.Skip(_),2),(x,y)=>{x{0}}&y))