I basically need to write a formula that does the following.

1. when no value is imputed into the designated space, do nothing.

2. when data is imputed (it will be a number from 1-99), I need it to do the following:

Type "1" 50 times vertically in a designated column, then start again at "2" fifty times and basically input that data equal times to the number placed in the designated space.

It will also, in a separate column, input a word 50 times in the same rows that the numbers it inputs are placed.

Example: in I1: I input the number 2

does this:


F G H
13 Defective 1
14 Defective 1
15 Defective 1
... ... ...
63 Defective 2
64 Defective 2


I doubt this can even be done, but i'm itching to find out if it can.