Friday, December 16, 2016

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