SOLVED

# Have my formulas copy while skipping 3 lines down at a time

Copper Contributor

# Have my formulas copy while skipping 3 lines down at a time

I am trying to copy down data in an excel sheet that has stacked lines of data that need to be extracted to their own columns.

I am hoping to have Column D(or some other pastable location )be:

D1:  =B1

D2:  = B4

D3: = B7

D4: =B10

Then have E have the next lines data:

E1:  =C1

E2: =C4

E3: = C7

E4: = C10

I'll then do a similar thing in Columns F where:

F1: = B2

F2:  = B5

F3: = B8

F4 = B11

And G

G1: = C2

G2: = C5

G3 = C8

G4 = C11

Does anyone have any suggestions on how to make this work?

2 Replies

# Re: Have my formulas copy while skipping 3 lines down at a time

@Russ1023 Use INDEX() with SEQUENCE() function.

``=INDEX(B1:B11,SEQUENCE(4,1,1,3))``

best response confirmed by Russ1023 (Copper Contributor)
Solution

# Re: Have my formulas copy while skipping 3 lines down at a time

@Harun24HR Thank you very much.

Russ

1 best response

Accepted Solutions
best response confirmed by Russ1023 (Copper Contributor)
Solution

# Re: Have my formulas copy while skipping 3 lines down at a time

@Harun24HR Thank you very much.

Russ