Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Break the table down into 1 increment

Hello,   I am trying to implement this logic but couldn't make it so far. This is as follows:   I have a table like this:   ID From To 11 0 2 22 1 3   I would like to brea...
  • v-yadongf-msft's avatar
    v-yadongf-msft
    4 years ago

    Hi   Anonymous ,

     

    Please select “Custom Column” in Power Query, and enter the following formula.

     

    You will get a new column as below.

     

    Click on the upper right corner and select “Expand to New Rows”.

     

    Then you can get result you want.

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

You can add a custom column in Power Query like 

{[From]..[To]}

then Expand it to New Rows