Analyze some Data

Hello, I would need to group multiple records into the same record based on a common ID. For Exemple ID State Client Price 0001 I A 10 0001 I B 11 Result should be ID Client ClientA Price Client ClientB Price 0001 A 10 B 11 I should also be able to manage Cancel and Cancel/Replace New records are added with state = I (Insert). A previous record is cancelled by providing a new record with state = C (cancelled) and the same trade identifier as the record being cancelled. A previous record is amended using a cancel/replace approach. First, the previous record is cancelled, and then a new (replacement) record is written with state = I (insert). Hope this is clear thanks