I have a table that contains a column with Initial Year and another with the number of amortisation years. I'm trying to generate a new table that duplicates the rows where amortisation years is >1 and recalcs the Year for each duplication.
I've drafted an example and the incomplete solution I got to so far: