XMPro provides a convenient Transformation Agent that allows you to first group by the specified column(s) i.e. the outgoing payload is a single event per identifier. And secondly, merge the data of the non-grouping columns: the data point is taken from the first event received in the batch where that column is not null.