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     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:| 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!

Thanks!
----------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment