How to process items grouped by a field, for multiple transformers.

I have 100 items of data, which are grouped together in various sub groups using a field 'groupNo',

I want to process each set of groupNos individually, I need to select a group, and do the following processes for each individual group: Take one item with status 'original' which has data and duplicate that data to the 'new' items in that group. How would I do this using the groupNo identifier? 

An example input output data set:
 

Input:
OID, Status, Data, Group
1, Original, XYZ, 1

2, New, <null>, 1

3, Original, ABC, 2

4, New, <null>, 2

5, New, <null>, 2

Output:

OID, Status, Data, Group
1, Original, XYZ, 1

2, New, XYZ, 1

3, Original, ABC, 2

4, New, ABC, 2

5, New, ABC, 2