Get data from alternated cells

[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

 

[Don Guillett]

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

 

[Debra Dalgleish]

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

 

[Ken Wright]

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