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

user Alex N said:(!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:
OUTPUT should look like: B6:B35
The closest formula I could come up with is in the cell D6:
However it outputs the result in a two-dimensional array, where I need the result in one column.

Thank you for your help.
following is a solution to the problem