Sunday, November 1, 2015

yogi_Rearrange Data From A MultiColumn Table Into Two-Column Table With The First Column Value Repeated For Each Row

Google Spreadsheet   Post  #1983
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-01-2015
post by  Aldo Huizinga:
https://productforums.google.com/forum/#!topic/docs/9d0pU_qFd5s;context-place=forum/docs
How can I transpose multiple columns into 2 columns?
I have multiple columns (57) and would like to transpose them like in this example.

I assume to use "ArrayFormula" but can not find the desired solution.

Hope any of you could help me.

Example




 A
1     1001
B
blue
C
1
D
aa
E
1a
2     2001red2bb1b
 3     3001black3cc1c


Desired solution
A   
    B
 1   1001blue
2   10011
3   1001aa
4   10011a
5   2001red
6   20012
...   2001bb
20011b
3001black
30013
3001cc
30011c

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