Looping through 2 cells, Concatenate the result

Input1: 1 Input2: 5 Result = 1, 2, 3, 4, 5

The user will give 2 inputs, in this case 1 and 5. On the same cell I want to loop and print the result as show 1, 2, 3, 4, 5.

Input1: 2 Input2: 6 Result = 2, 3, 4, 5, 6

is there any function that can give this result? I know how to do it with while loop in python and I am not sure if we have the same in excel. Thank you[table="width: 500"]

Input1	Input2	Result/Function
1	5	1, 2, 3, 4, 5
2	6	2, 3, 4, 5, 6

UDF

Please Login or Register  to view this content.

in C1

=Listn (A1,B1)