yogi_Append In Cell B6 Names In Row 2 Number Of Times As Noted In Row 3 Starting from Column D On

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #629   Jul 15, 2012     www.energyefficientbuild.com.


user Alex N said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/_N4ITMMAajw)
Copy cells N times in one column
Hello there,

There is a spreadsheet that I am working on. It will be completed as soon as I solve the following problem.

INPUT: first row with names, second row with a number (N) under each name.

OUTPUT: each name copied into N cells. the result should be in one column

Here is a spreadsheet with an example:

https://docs.google.com/spreadsheet/ccc?key=0Aj5jO5HGOSRQdC1xRU5hN1NzUVREOGtLTzhhbl9QYWc

INPUT: D3:H3 

OUTPUT should look like: B6:B35

The closest formula I could come up with is in the cell D6:

=ARRAYFORMULA(IF(ROW(D6:D27)-5<=D3:H3,D2:H2,))

However it outputs the result in a two-dimensional array, where I need the result in one column.

Thank you for your help.

~Alex

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

following is a solution to the problem