Tuesday, August 12, 2014

yogi_Repeat Entry In Cells Of Column B Based On Number In Corresponding Row Of Column A

                        Google Spreadsheet   Post  #1725
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-11-2014
post by Agam sharma:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/ZXVAhjQdl3U)
populate word in different cell depend on number input in different column
Hi,
as below example,
can we populate the column 1 cell in different cells depend on column times? I find it hard to explain, please let me know if you do not understand my question.
 
Timescolumn 1
3Adam
2sam
4job


expected result to appear


adam
adam
adam
sam
sam
job
job
job
job
---------------------------------