Column value to rows

[AndersASorensen]

I would like to create a table with a count up to the column value.

So from this

ID	Period
1432	4
2342	2

To this

ID	Period
1432	0
1432	1
1432	2
1432	3
1432	4
2342	0
2342	1
2342	2

[serpiva64 · Accepted solution]

Hi,

you can add a custom column

{Number.From(0)..Number.From([Period])}

then Expand to new rows

and that's done

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !