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     2001	red	2	bb	1b
3     3001	black	3	cc	1c
Desired solution A	B
1   1001	blue
2   1001	1
3   1001	aa
4   1001	1a
5   2001	red
6   2001	2
...   2001	bb
2001	1b
3001	black
3001	3
3001	cc
3001	1c

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