Decrease Redundancy in Dataset with various data rows
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
matbae
6 - Meteoroid
‎01-09-2023
05:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Labels:
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
‎01-09-2023
05:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎01-09-2023
05:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
