how to copy rows depending on column values

[utkuacik]

Hi guys, so sorry if this question is asked before , but after searching 3 day in internet , i could not find a solution , probably i am new to power BI and M language.  so sorry if i made aa mistake , cause it is my first time writing to a forum . thank you all

i have a table with 13 columns.   i just want to copy rows according to values in columns named "from" and "to" .  

[HotChilli · Accepted solution]

In power query, Add Column -> custom column.

{[From]..[To]}

then Expand the column (from the header) 'to rows'

[utkuacik]

you are my hero 🙂 thank you so much