title: Autofill numbers based on column
body: <p>This may seem extremely elementary, however, I haven't been able to figure it out. I am wanting to be able to autofill a number series up to 6.</p>
  <p>For example, the column would go from 1, 2, 3, 4, 5, 6 down each row, and then start over after 6. The columns in A2 would have the item and the columns in f are the position of the item in the gallery (crm requires 6 for each). Basically, it would repeat itself based on column A2. Is there a formula or an array type formula for this or something like it?</p>
  <p><a href="https://i.stack.imgur.com/MZhmb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MZhmb.png" alt="enter image description here" /></a></p>