copy rows question

M

mike

how can I take a column populated with a list of unique values and manipulate
it to get a new column with 6 of each of the values, consecutively?
 
M

mike

Ok I figured it out, I'll post the answer in case its helpful.

Create a helper column with six rows of '1' followed by six '2's, six
threes, etc.

in an another column use (assuming your original data is in column A, and
your helper column is B) =INDEX(A:A,B1,1) and drag the formula down.

Mike
 
Top