copy & past row to column

[James]

I want to copy a row of data and past it into a column. however i only want
to pick up every other cell or every third cell. for instance i have names
going across the row but thier are a few columns in between each name and i
want to past the names like a list in one colomn. I also want to past parts
of the data for each name in that same format. Any idea for the easiest way
to handle this?

thanks

 

[Max]

I want to copy a row of data and paste it into a column.

.. every third cell

Insert a new col A. I'll presume the names data are now in B1,E1,H1, etc
Place in A2: =INDEX($B$1:$IV$1,ROWS($1:1)*3-2)
Copy down as far as required to extract at one swoop

---

 

[RagDyeR]

Say your data is in Row1.

Enter these formulas *anywhere*, and copy down as needed:

To skip *1* row in between:
=INDEX($1:$1,2*ROWS($1:1)-1)

To skip *2* rows in between:
=INDEX($1:$1,3*ROWS($1:1)-2)


To skip *3* rows in between:
=INDEX($1:$1,4*ROWS($1:1)-3)

I'm sure you can adjust the formula for other choices.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I want to copy a row of data and past it into a column. however i only want
to pick up every other cell or every third cell. for instance i have names
going across the row but thier are a few columns in between each name and i
want to past the names like a list in one colomn. I also want to past parts
of the data for each name in that same format. Any idea for the easiest way
to handle this?

thanks

 

[James]

Thanks guys Max's worked best.

Insert a new col A. I'll presume the names data are now in B1,E1,H1, etc
Place in A2: =INDEX($B$1:$IV$1,ROWS($1:1)*3-2)
Copy down as far as required to extract at one swoop

 

[Max]

Welcome, but pl mark all our wonderful responses by pressing the "Yes"
buttons below, won't you?