Create a new row for a range of two columns PowerQuery

[msantin]

Hello everyone,

I have a question to perform a transformation in PowerQuery. I explain:
I have a table with two columns that have a range of "accounting accounts" and I would like it to generate a row for each account that is in the range.

Example:

New rows:

0 609001 

0 609002

0 609003 ... 0 609999

Is it possible to perform this?

Best regards

[amitchandak · Accepted solution]

@msantin , Use List.Numbers to create a new column and then expand that

Power Query- List.Numbers: https://youtu.be/7_4V_Om-FEk

List.Dates example - Same will trye for List.Numbers

https://medium.com/@amitchandak/power-bi-power-query-vs-dax-months-between-range-df019cec823b