Friday, May 3, 2013

yogi_Extract Groups Of Values From Column A Starting With A1 A2 A3 Etc With A Specified Step Value


                                          Google Spreadsheet   Post  #1168
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 04, 2013
user Fun SpiritMan (http://productforums.google.com/forum/?zx=crpyw0e3sdva#!category-topic/docs/spreadsheets/5ZbZBFziPDQ)
How to copy data from column A to columns B and C, effectively using half the number of rows
I have data in column A that I want to duplicate in columns B and C as follows:

       A       B     C
1)     6       6     5
2)     5       4     3
3)     4       2     1
4)     3       7     8
5)     2       9     13
6)     1      14
7)     7
8)     8
9)     9
10)   13
11)   14
---
Update: The ideal solution would allow me to use up to 4 columns (B, C, D, E) to represent the data in original column A. Here is a second 
view of the data and results using the max of 4 columns:


       A       B     C    D    E   
1)     6       6     5     4     3
2)     5       2     1     7     8
3)     4       9     13   14
4)     3          
5)     2       
6)     1      
7)     7
8)     8
9)     9
10)   13
11)   14

Any help would be appreciated. Thanx. 
----------------------------------------------------------------------------------------------------------------
following is a solution to the problwm