Get data from alternated cells

  • Thread starter Thread starter carlos.cruz
  • Start date Start date
C

carlos.cruz

Hi,

Imagine that the data I want to read and join in column is in a column but
in alternated rows. I mean:

A1 = 'Data1'
A5 = 'Data2'
A10 = 'Data3'
A15 = 'Data4'
...
...
...

and I would like to have another column (ex: Z) with:

Z1 = A1
Z2 = A5
Z3 = A10
...
...
...

Is there a way to do this????

Thanks
SCP
 
one easy way is to
=a1 in one cell
=a5 in cell below
highlight both & use the fill handle (bottom right of bottom cell) & drag down

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hi,

Imagine that the data I want to read and join in column is in a column but in alternated rows. I mean:

A1 = 'Data1'
A5 = 'Data2'
A10 = 'Data3'
A15 = 'Data4'
...
...
...

and I would like to have another column (ex: Z) with:

Z1 = A1
Z2 = A5
Z3 = A10
...
...
...

Is there a way to do this????

Thanks
SCP
 
In cell Z1, enter: =A1
In cell Z2, enter: =INDIRECT("A"&ROW()*5-5)
Select cell Z2, and copy the formula down as far as required
 
Please try not to post to multiple groups, as it would save a lot people
answering the same question with the same answer :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------




Hi,

Imagine that the data I want to read and join in column is in a column but in
alternated rows. I mean:

A1 = 'Data1'
A5 = 'Data2'
A10 = 'Data3'
A15 = 'Data4'
....
....
....

and I would like to have another column (ex: Z) with:

Z1 = A1
Z2 = A5
Z3 = A10
....
....
....

Is there a way to do this????

Thanks
SCP
 
Back
Top