If u hav an inique ID or primary key for the table u can Use this Logic

that means

PID|Product|STATUS|BEGIN|TRX|END

1 A IN 0 5 0

2 A...