Sunday, July 15, 2012

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:
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