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!

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