title: Excel - Copy each value as many times as there are sequence numbers in another column
body: <p>I have the below dataset:</p>
  
  <pre><code>A B
  1 Apple
  2 Mango
  3 Orange
  </code></pre>
  
  <p>And I'm trying to replicate each value of the B column as many times as there are sequence numbers in the A column (same sheet or another sheet doesn't matter):</p>
  
  <pre><code>A B
  1 Apple
  2 Apple
  3 Apple
  1 Mango
  2 Mango
  3 Mango
  1 Orange
  2 Orange
  3 Orange
  </code></pre>
  
  <p>But I'm unable to come up with a way to achieve this. How do I achieve this without VBA?</p>