| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Copy/Paste question | Excel Worksheet Functions | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
| Copy worksheet question | Excel Worksheet Functions | |||
| Copy Paste Question | Excel Discussion (Misc queries) | |||
Hybrid Mode
