distribute number on excel cell according to value

dear all
please see my attached file with sample that i want to do like automatic
when i enter value in cell like 10
in other column that have formula wrote the following
1
2
3
4
5
6
7
8
9
10
and if i wrote any other value it directly fill automatic cell