How to make a sequence in google sheets which has increments in regular intervals

Question

I want to create a sequence in google sheets where i have to make a sequence of this sort like if the sequence starts at 5000, it should be 5000 for the next 12 rows and then it should increment to 5500 and then it should go on for another 12 rows to be 5500. So basically it should increment by 10% after 12 rows and continue to do this.

Answer 1

=ArrayFormula(vlookup(quotient(sequence(Blocklength*Blocks,1,0),Blocklength),
{sequence(Blocks,1,0),Start*(1+Increment)^(sequence(Blocks,1,0))},2))

Comment

You don't actually need the vlookup, could go straight to the calculation, but with a power calculation in every row this might be slower:

=ArrayFormula(Start*(1+Increment)^quotient(sequence(Blocklength*Blocks,1,0),Blocklength))