Sunday, November 26, 2017

yogi_For Entities In Column A (range A17:A) Create Specified Number Of Consecutive Rows For Each Entity

Google Spreadsheet   Post  #2303

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-26-2017
question by: Boris (fxpr)
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/dpacm9LquDY;context-place=topicsearchin/docs/authorid$3AAPn2wQc7O4EQsX1gkj1mKYiVqjACnXxOUJfDW9aP6REEoSb26rzIBkrBhpHOgIm3cS21f6-y3rVl%7Csort:date%7Cspell:false
Need your help with google sheets
Hi! 

Could you pls help me with this problem: how to convert 1 number to some words? 

I have the next situation:

There are X social networks (then "SN"). for example X=10.
On the each one I need to answer questions particular times, for example:

SN 1 = 2 answers
SN 2 = 3 answers
SN 3 = 1 answer 

On the sheets I need to get this table

List 1:
SN 1 = facebook   = 2 answers
SN 2 = youtube     = 3 answers
SN 3 = instagram  = 1 answer

List 2:

facebook
facebook   
youtube     
youtube     
youtube     
instagram  
instagram  
instagram  

___

Thank you