Date wise Amount. Getting opening and closing balance from one field.

Hi guys,

I have a requirement where :

Open date Open Amount Close date Close Amoumt

202112 56456 l 202201 76589

must come as:

202201 76589 l 202202 98767

But I am not able to get the previous month closing amount as opening amount in current month.
the amount is coming from same field.

Suggestions will be helpful.

Than