title: Expanding singular cell into multiple rows based on number in the cell - EXCEL
body: <p>I have a spreadsheet containing a column of numbers. </p>
  
  <p>For every value within the reference column, I need the to excel to produce a row of number in the adjacent column with values starting from the number 1, incrementally increasing by 1 and ending once the reference value is reach. This then needs to be repeated for the next value in the reference column and so on, continuing to expand in the adjacent column. </p>
  
  <p>Below is an example of the reference column containing 3 values and what i did manually adjacent. Can some please help me write function in VBA so that i dont need to do this manually.<br>
  <a href="https://i.stack.imgur.com/mXhff.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mXhff.png" alt="example of what i need the function to do"></a></p>
  
  <p>Thanks for the help in advanced. </p>