How to use Multi-Row formula to get the desired output

[AKPWZ]

I'm trying "If StartsWith(JSON_Name,'data.rows.0') Then [Row-1:Counter]+1 Else[Row-1:Counter] EndIf"  into Mmulti-Row formula tool to get the desired output (attached screenshot), but not sure what I'm doing wrong and getting something else.

I want to use a counter whenever there is a change - like;  'data.rows.0' to 'data.rows.1' and likewise

Please review my logic and help me to get the right solutions. Thanks

[RobertOdera]

Sure thing, @AKPWZ .

Happy to help.

Please mark it as an acceptable solution - cheers!

[RobertOdera]

Actually, @AKPWZ 

@ShankerV updated solution will now also work for you - kindly credit @ShankerV  for the solution given first responder to your question. Or mark both as solutions if that is possible 😎

[AKPWZ]

Thank you @ShankerV Its working for me. :)