Generate a number sequence in a single Cell

[luke1986]

Hello Folks,

This is a trickey one, my Sample Data looks like this:

ID	From-To	Sequence
1	10-70	10
2	20-50	10

The Output should look like this:

ID	Output
1	10,20,30,40,50,60,70
2	20,30,40,50

Has any one a solution?

Thanks

[tresesco · Accepted solution]

And tricky sometimes draws more attention!  Try like:

Load
	ID,
	Concat(Output, ',') as Output
Group By ID;	
Load
	ID,
	From+Sequence*(IterNo()-1) as Output
While From+Sequence*(IterNo()-1) <=To;	

Load *,
	SubField([From-To], '-',1) as From,
	SubField([From-To], '-',2) as To
Inline [
ID,	From-To,	Sequence
1,	10-70,	10
2,	20-50,	10]

[luke1986]

Nice One! Thanks!