Thursday, June 12, 2014

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   Jun-11-2014
post by DrFriFox: (!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.


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

B:| C:| D:D
1-| 1-| 1-C2-| 2-| 2-C3-| 3-| 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!