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:

 

IDFromTo
1102
221

3

 

I would like to break it down into 1 increment so:

 

IDNum
110
111
112
221
222
223

 

Please advice!

Thanks

  • 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.

2 Replies

  • 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

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    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.