Repeating number of Rows

[#1]

Hi Guys

I have a table as Follows:

DimensionCode	To	From
1A	1	3
1B	6	8

and i want the output as

DimensionCode	To	From	Range
1A	1	3	1
1A	1	3	2
1A	1	3	3
1B	6	8	6
1B	6	8	7
1B	6	8	8

[Gysbert_Wassenaar · Accepted solution]

Something like this:

Result:

load DimensionCode, To, From, To + iterno() -1 as Range

from ...somewhere...

while To + iterno() -1 <= From;