title: Having REPT function iterate over multiple values
body: <p>Hi I'm curious if this is even possible and just thought I'd throw it out.</p>
  <p>I have this function in google sheets:</p>
  <p><code>=ArrayFormula(TRIM(TRANSPOSE(SPLIT(QUERY(REPT(UNIQUE('Data Validation'!B3)&amp;&quot;,&quot;,'Data Validation'!C3),,999^99),&quot;,&quot;))))</code></p>
  <p>It allows me to specify the thing I want repeated as well as the number of times I want it repeated. Both of those are found in my data validation sheet which contains the following:</p>
  <p><a href="https://i.stack.imgur.com/Zanqa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Zanqa.png" alt="enter image description here" /></a></p>
  <p>I am curious if there is a way to build the array formula so it essentially says:</p>
  <p><code>repeat each element in column B the corresponding number of times in column C</code></p>
  <p>Or in other words repeat <code>EVP Sales</code> 380 times then in the same output column repeat <code>VP Inside Payments</code> 36 times etc.</p>
  <p>I haven't found anything remotely related to this online.</p>
  <p>Thanks!</p>