How do I create rows in a table based off a cell value and fill a column also based off the cell val-CodePudding

I am looking to create and fill a table based on two cell values. If D2 and E2 contain the values 64 and 8 respectively. I want to create a column in a table that has 64X8 rows (not a 64x8 table). Then I want to fill the column with values 0-63 and repeat 8 times.

For example, the table will have a column with values:

The 0-63 pattern repeating 8 times.

Is this possible? Sorry if my explanation isn't clear. I can provide more detail.

CodePudding user response：

Try below formula-

=MOD(SEQUENCE(D2*E2,,0),D2)