hello!

can anyone help me achieve this please (I dont know if regex or macro or anything else is the appropriate way):

I have a text with many lines in this format:

GROUP1{TAB}ITEM1{TAB}SENT
GROUP1{TAB}ITEM2{TAB}SENT
GROUP2{TAB}ITEM3{TAB}SENT
GROUP2{TAB}ITEM4{TAB}NOT SENT
GROUP2{TAB}ITEM5{TAB}SENT

GROUP1, GROUP2, etc are multidigit numbers

ITEM1, ITEM2, etc are any kind of characters sequence, including TABs, spaces, etc

the logic is that if in a GROUP, there is a single or more ITEM that is NOT SENT, then the whole GROUP must be marked as NOT SENT

if all items of a GROUP are SENT, then the GROUP is marked as SENT

so I want, with a click, to transform the above text into:

GROUP1{TAB}SENT
GROUP2{TAB}NOT SENT

any solution?

thanks!