# Insert and paste 3 rows in every other row of a sheet

1. ## Insert and paste 3 rows in every other row of a sheet

I have a sheet with 1000s rows of products data. The problem is each product, since its a variable products, has to have three additional row below it. Now the three additional rows are always the same. So lets say
OK I think I made an error in the question so

I have in sheet1
Product 1 Price Description SKU Image
Product 2 Price Description SKU Image
Product 3 Price Description SKU Image
Product 4 Price Description SKU Image

Another sheet2
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}

I want sheet 3 be like
Product 1 Price Description SKU Image
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}

Product 2 Price Description SKU Image
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}

Product 3 Price Description SKU Image
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}

Product 4 Price Description SKU Image
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}
....

Now I know I have to be able to select every other row in my sheet first insert three blank rows below it and then paste them in there. Or if there is any easier way to do this please let me know.

2. ## Re: Insert and paste 3 rows in every other row of a sheet

assuming as you've shown what you have in the original sheet
put this in the results sheet in A2 and drag right then down until it returns zero...
=INDEX(Sheet1!A\$2:A\$1000,ROUNDUP(ROW(A1)/4,0))
extend the rows if needed.

3. ## Re: Insert and paste 3 rows in every other row of a sheet

I attached a sample file
OK I think I made an error in the question so

I have in sheet1
Product 1 Price Description SKU Image
Product 2 Price Description SKU Image
Product 3 Price Description SKU Image
Product 4 Price Description SKU Image

Another sheet2
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}

I want sheet 3 be like
Product 1 Price Description SKU Image
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}

Product 2 Price Description SKU Image
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}

Product 3 Price Description SKU Image
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}

Product 4 Price Description SKU Image
Option size {1,2,3,4,5....}
Option color {red, rose, black}
Option last {x, y, z}

options never change or get incremented in anyway

4. ## Re: Insert and paste 3 rows in every other row of a sheet

Try the following:
Formula:
`Please Login or Register  to view this content.`

Let us know if you have any questions.

There are currently 1 users browsing this thread. (0 members and 1 guests)