Please anyone help me to write my desired query as per Sample Output

I have a table in MS access (2016 version) name Transaction Table, given following: Transaction Table ID Transaction Date Receive Payment 1 01-Mar-20 50   1 ...