How to Loop numbers in a column?

[davidi123]

I want to loop number 1 - 12 in a new column: it would look like:

x     x     x        1

x     x     x        2

x     x     x        3

.

.

.

x     x      x     11

x     x      x     12

x     x      x      1

x     x      x      2

Like this, x can be anything. I just want to loop numbers based on row position. Thanks for your help

[Felipe_Ribeir0 · Accepted solution]

Hi @davidi123 

I dont know if i got what you need, but based on your example table, i understood that you need to create a record for the row, count until 12 and then restart. If this is the case, you can do it using the multi row formula: