Moving data from one sheet to new sheet - not in sequential order

[jc2018]

Hi Everyone,

Need help please!

I have a list of data on one sheet... imagine column A has data in each row 1-4

On a seperate sheet I need to pull that data and insert every 6 rows....

For example:
Sheet 1 A1 would go to Sheet 2 A1
Sheet 1 A2 would go to Sheet 2 A7
Sheet 1 A3 would go to Sheet 2 A13
Sheet 1 A4 would go to Sheet 2 A19

Any thoughts on a formula that I could drag down over houndreds of cells?

Thank you for your help!

[Pepe Le Mokko]

Try =IF(MOD(ROW(),6)=1,INDEX(Sheet1!$A$1:$A$20,(ROW()-1)/6+1),"")
starting in A1 sheet 2 and drag down as needed
Adapt ranges to your needs

[jc2018]

Attached is an example of what I am looking to do...

I need the data shown on sheet 2 to move to the corresponding columns on sheet 1

Sheet 2 row 2 column a should move to sheet 1 row 2 column B

Sheet 2 row 3 column a should move to sheet 1 row 8 column B

Sheet 2 row 4 column a should move to sheet 1 row 14 column B

I want to set up a formula to move all the data from all columns of sheet 2 into their corresponding place on sheet 1 and be able to drage this down so it applies to a full workbook of data.

Thank you for your help!

[Pepe Le Mokko]

Have you read post #2? You can easily adapt it
Will there be any other changes to your initial request?
Basic courtesy would be to at least acknowledge my answer !

[jc2018]

Hi Pepe,

I wasn't trying to be rude... I responed to your first message instructing me to attach a sample.

When I tried your formula it did not work... I got an error message that said "you've entered too many arguments"

Any other ideas? Could you try mocking up your formula in the sample I attached?

[JeteMc]

This proposal employs a helper column (K) which may be moved and/or hidden for aesthetic purposes.
Paste the following formula into K2 double click the fill handle to copy down to K36: =COUNTIFS(A$1:A2,A$1)
The formula for cell B2 is: =INDEX('sheet 2 '!A$2:A$7,$K2)
Once the formula is entered into cell B2 the fill handle may be dragged across to cell G2
Select cells B2:G2 and press the Ctrl and c keys
In turn select cells B8, B14, B20 etc. and press the Ctrl and v keys
Note that you could eliminate the helper column by using following formula instead: =INDEX('sheet 2 '!A$2:A$7,COUNTIFS($A$1:$A2,$A$1))
However that will require the COUNTIFS to calculate the value six times for each row, as opposed to once using the helper column, which is not an efficient use of computer resources.
Let us know if you have any questions.