split values into multiple rows

[pBur]

Hi guys, I am having a little challenge with splitting a row into multiple rows, based on values. Background: the idea is to create a "what if" analysis with a parameter table. The user inputs the parameter values (in my case percentage range) and I want to use that range in a numeric slider. So here's an example on what I have and what I need to achieve:

 And what I need: 

create a range from 0 to 100 (or any given numbers) with increment of 2 (step) 

Result: 
0
2
4
6
8
...
100

Any ideas? I've been reading similar posts about splitting into rows, however couldn't apply anything on this scenario... 😕 

I've been trying out to reach a solution wiht PowerQuery however my knowledge is limited in this case. 

[MarcelBeug · Accepted solution]

In Power Query, you can use

= List.Numbers(0,51,2)

 which will give you a list, starting with 0, 51 elements, increment of 2.

Alternatively, if the result would be an additional column to a table, you can use Add Column - Index Column - Custom...

[pBur]

Thank you! I was so close! 🙂 This should work for me with a few adjustments.