Google Sheets - Auto Increment numbers based on a cell value

Question

I am currently trying to make number increment based on a cell value For example, if the cell value is 5, then a number increment should appear shows in row by row as

1
2
3
4
5

Anyone has ideas on how to do this?

Answer 1

You need SEQUENCE() function. Try-

=SEQUENCE(B1)

Reference:

• SEQUENCE