yogi_Rearrange Data From Columns Into Alternating Rows

Google Spreadsheet   Post  #2096

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-16-2016

question by: mervin 123:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/O5FQNx14BwU;context-place=mydiscussions

Alternating Cells

I wanted to know if anyone has an idea how to accomplish something I am trying.  I can figure out how to pull data from one cell to another sheet, but What I want to do is have the data alternate cells in my destination  Does anyone know how to do this?

Basically I want to pull everything from Column A1 through A100, and place it onto a different sheet in Column A1, A3, A5, A7, A9 etc.

Edited