title: Repeat a specific text x number of times in one column taken from another column of Random text strings
body: <p>I have some Text Values in sheet 1, A4:A400 and for each value in Column A there are 10 codes in non-consecutive cells in Row 1.
  I want a formula in "sheet 2" to put each text value 10 times in column A with the code in column B and then repeat the same with a new text value with the same 10 cods.
  LIke:</p>
  
  <pre><code>1
  2   . . . . . . 5310    5200        3310    3456            3600
  3   PK64                                
  4   PK967                               
  5   PK106                               
  6   PK369                               
  7   PK250                               
  8   PK222                               
  </code></pre>
  
  <p>It should look like this                                    </p>
  
  <pre><code>1   A       B                           
  2   PK64    5310                            
  3   PK64    5200                            
  4   PK64    3310                            
  5   PK64    3456                            
  6   PK64    3600                            
  7   PK967   5310                            
  8   PK967   5200                            
  9   PK967   3310                            
  10  PK967   3456                            
  11  PK967   3600                            
  </code></pre>
  
  <p>I used <code>=INT((ROW()-1)/3)+1</code> but it increments and repeats the number only.</p>
  
  <p>I also used <code>=REPT(B1,ROW()-1/5)</code> but it repeats the text in the same cell with increased number of times as the row number increments.</p>