title: Generate multiple rows of data based on 1 row input - Google Sheets
body: <p>I'm trying to create an automation in my backend in Google sheets dashboard to make it easy for me to scale a certain report that I'm creating.</p>
  
  <p>Basically, I want to Generate multiple rows of data based on 1-row input done in a certain place. This is basically regarding recurring income and recurring expenses that are repeating monthly or quarterly. So the generation of multiple rows should be based on "Recurring months time", "Recurring income" and "Recurring expense". The main thing is to add dates also here - by the amount of time it keeps repeating. The loop and repetitions should go on until a decided date in 2019-2020 etc.(Say 1 Jan 2019)</p>
  
  <p>Detailed example below, the input table is done by an individual - whereas the output table is generated automatically by the script, code and formulae</p>
  
  <p><a href="https://i.stack.imgur.com/oTlvj.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oTlvj.jpg" alt="Example Input and output tables"></a></p>
  
  <hr>
  
  <p>Hope this explains my problem statement clearly. I think we will have to use "Google Apps Script" here to create the loop from the input statements.</p>
  
  <p>Any approach and help in solving this would be highly appreciated.</p>