Forum Discussion

SteelerFan's avatar
SteelerFan
Frequent Visitor
3 years ago

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              ...
Need Help
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

=#table({"PIDM","College","VP"},List.TransformMany(Table.ToRows(YourTable),each List.Split(List.Skip(_),2),(x,y)=>{x{0}}&y))