Break the table down into 1 increment

[Anonymous]

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 break it down into 1 increment so:

ID	Num
11	0
11	1
11	2
22	1
22	2
22	3

Please advice!

Thanks

[v-yadongf-msft · Accepted solution]

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]

You can add a custom column in Power Query like 

{[From]..[To]}

then Expand it to New Rows