copy rows question
 

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?

copy rows question
 

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

"mike" wrote:

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?