Friday, June 13, 2014

yogi_Split Entries Into Columns D G And J By First Second And Third Rows Of Sets Of 3s In Column A


                                         Google Spreadsheet   Post  #1671
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-13-2014
post by DrFriFox: (https://productforums.google.com/forum/#!mydiscussions/docs/PI3CdCruSj8)


Spreadsheet:

See the "Coefficients (WvW)" tab. Source data is in A column, and the split data are the 3 columns - D, G, and J.
---
And the goal,

Column A, rows 1,4,7,10,13,16,19... (x+0) into Column D
Column A, rows 2,5,8,11,14,17,20... (x+1) into Column G
Column A, rows 3,6,9,12,15,18,21... (x+2) into Column J
----------------------------------------------------------------------------------------------------------------------------------------------