copy rows question

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy rows from one worksheet automatically, ignore rows that are b	Kris	Microsoft Excel Worksheet Functions	2	10th Oct 2008 09:28 PM
Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows	Corey	Microsoft Excel Programming	2	1st Aug 2007 02:02 AM
Copy rows of data (eliminating blank rows) from fixed layout	=?Utf-8?B?U3dlZXBlYQ==?=	Microsoft Excel Misc	1	13th Mar 2007 11:05 PM
copy and past Rows with exception of Hidden Rows	Molly	Microsoft Excel Misc	1	11th Jul 2003 01:00 PM
Re: copy and past Rows with exception of Hidden Rows	Ken Wright	Microsoft Excel Misc	0	10th Jul 2003 10:42 PM