Substituting this month's end balance as the opening balance of the next month

[chetan_064]

For example if I have an input which says that as of 31st January the balance was 1 , then it should be the opening balance on 1 February and this balance should also be the same until the balance changes in February and suppose if the balance changes on 24th February till 28th February to 3, then that should be the opening balance on March 1st. 

Please do let me know if somebody has a solution for this.

[sparksun]

A Multi-row Formula tool could do it.

[chetan_064]

Thank you! But in my scenario the input won't be null in any case but rather there would be values in each row for balance.

[sparksun]

So why not give your sample data to clarify your specific scenario?