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   Jun-13-2014
post by DrFriFox: (!mydiscussions/docs/PI3CdCruSj8)


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