PRO 00001 00001 AAA
PRO 00001 00001 BBB
PRO 00001 00001 AAA
PRO 00001 00001 AAA
CTR 00001 00001 CCC
CTR 00001 00001 BBB
CTR 00001 00001 BBB
CTR 00001 00001 AAA
PRO 00001 00001 BBB
PRO 00001 00001 AAA
PRO 00001 00001 AAA
CTR 00001 00001 CCC
CTR 00001 00001 BBB
CTR 00001 00001 BBB
CTR 00001 00001 AAA
I also need to sum some fields and get something like:
PRO 00001 00003 AAA CTR 00001 00001 CCC
PRO 00001 00001 BBB CTR 00002 00002 BBB
CTR 00001 00001 AAA
PRO 00001 00001 BBB CTR 00002 00002 BBB
CTR 00001 00001 AAA
Thanks!