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
