To insert data of alternate cells

[friend_12]

Hi,


I want to insert data of cell A1,A3,A5 & so on into B1,B2,B3...


Do we have any formula to do so.


Please help as manually it is taking too much time.


Thanks !!

 

[sgmpatnaik]

@friend_12


Hi


Firstly welcome to Chandoo.org Forum, glad you are here


before replay your question i would like to suggest some important things


1. Please read the 3 green sticky keys of this forum


2. Please provide the Forum readers with full details


3. Before posting any question please use the Search button which is located in upper right corner of this forum may be your question before asked and answered


4. Use the given link to upload a sample file which is better to understand your problem

http://chandoo.org/forums/topic/posting-a-sample-workbook


Hope you understand


Thanks


SP

 

[Hui]

Friend_12


In B1 put: =OFFSET($A$1,2*(ROW()-1),0)

Copy down