Transpose Function Using Index

[Andrew_Seaman]

Here is my source data:

I would like to transpose this into the following format.  The start Index is from column B and adds 1 unit it reached the end index.  In some cases this may span 30+ numbers.

Any thoughts on how to accomplish this in a workflow?

[apathetichell]

This is a generate rows problem.... I can give you a quick workflow - or I can point you to generate rows and recommend you try something like:

[start] in your initial value section

and <= [end] as your condition...

solution posted. Play around with the generate rows tool though it's super useful to create ranges.