Is it possible to create a table in Excel, the number of rows in which will depend on the parameter (value in the cell)?

Question

excel

I am doing the calculation of loan payments and I need that when I put the number of months in the cell, my table has the same number of rows.

Answer 1

Make a column with the parameter yes/no. The formula for it is:
=СТРОКА()<=$D$1, where D1 is the specified number of cells
Next is a filter for the entire table with a condition on this column.