0

I have a table as bellow in Excel and I would like to copy rows 3, 7, 11, 15, 19,...on the left to the right as in the picture. Is there a function to do this? Thank you for help.enter image description here

Improve this question
4
  • Why do you want to copy them? The data is the same.
    – DavidPostill ♦
    May 12, 2016 at 18:10
  • What is special about those rows or is it arbitrary?
    – Scott Craner
    May 12, 2016 at 18:10
  • Hi, I want to separate these rows in a separated table.
    – emnha
    May 12, 2016 at 18:11
  • The rows have pattern like this 3, 7, 11,..., n, n + 4
    – emnha
    May 12, 2016 at 18:12

1 Answer 1

Reset to default
1

Put this in J3 and copy over enough columns and down enough rows:

=INDEX(A:A,((ROW(1:1)-1)*4)+3)

enter image description here

Improve this answer
2
  • Thank you very much for the help, expert. I will study the function. I tried to use OFFSET function today but it couldn't make it work.
    – emnha
    May 12, 2016 at 18:29
  • @user3126592 I avoid the OFFSET and INDIRECT as often as possible as they are volatile functions, in that they recalculate every time excel recalcs regardless if the data to which it refers changed or not. If you have a sheet full of them it will impact the calculation times.
    – Scott Craner
    May 12, 2016 at 18:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .