Decrease Redundancy in Dataset with various data rows

[matbae]

Hello all,

I have the following data. These contain redundancies, which are marked in red. The orange data is the original data to keep.

As you can see in the screenshot, the redundant records can span one, two, three, four, etc. rows.

Records are considered redundant if they follow directly after the original record(s) - keep in mind, that sometimes they can span more rows.

They have the same category and the same value in in Debt /Credit as the original data in orange.

Looking forward to your solutions!

THX!

[Felipe_Ribeir0]

Hi @matbae 

See if this works for you:

[binuacs]

@matbae One way of doing this this with the unique tool