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:

- https://docs.google.com/spreadsheets/d/1Yt0WNbgZkbn1W0Y89v7IatIujauTTQ3XbU1iTqRd7qc

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

----------------------------------------------------------------------------------------------------------------------------------------------

yogi_Split Entries In Column A Into Different Columns Beginning With 1 And Successlvely Increasing By 1

                                         Google Spreadsheet   Post  #1667
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-11-2014
post by DrFriFox: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/PI3CdCruSj8)
Split data from one column into 3 other columns?

I have a huge dataset in one column (A:A), which is actually a collection of smaller datasets that spread only 3 cells.

A:A---
1-A1-B1-C2-A2-B2-C3-A3-B3-C

I need to somehow split it into 3 different columns on the same sheet (into B:B, C:C, D:D), example:

B:B | C:C | D:D
---------------
1-A | 1-B | 1-C2-A | 2-B | 2-C3-A | 3-B | 3-C

This is so then I can reference samples by B:B - the 1st values in each set, C:C - the 2nd values in each set, and D:D - the 3rd values in each set for simple functions such as =average(X:X), =minimum(X:X), and =maximum(X:X) somewhere else in the spreadsheet.

I'm at a complete loss on how to accomplish this. Any tips will be greatly appreciated!

Thanks!

----------------------------------------------------------------------------------------------------------------------------------