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

> 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"James" wrote:
> 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

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!
=====================================================


"James" <(E-Mail Removed)> wrote in message
news:BD56D0DD-764F-49F6-B745-(E-Mail Removed)...
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

Thanks guys Max's worked best.

"Max" wrote:

> > 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
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "James" wrote:
> > 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

Welcome, but pl mark all our wonderful responses by pressing the "Yes"
buttons below, won't you?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"James" wrote:
> Thanks guys Max's worked best.