Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
I have a file with duplicate records but the critical field (Description) has been updated in some cases and that is the one that needs to be returned.
What I need as output would be:
Building entry All Entering the building, requires ID card
so that each process is only listed once but it picks up the Description field with the most information ie has more text in it. As far as I can see no process has more than 2 entries, there are a lot of entries though where there's just one entry. How do I merge these records and remove duplicates?
Process | Affects | Revision | Description |
Building entry | All | Entering the building | |
Building entry | Entering the building, requires ID card | ||
OHS | Refer manual | ||
OHS | Refer manual | ||
Recruitment | Jun-20 | Refer HR | |
Photocopying | Office | Requires training | |
Photocopying | Office | Requires training. Update imminent |
What I need as output would be:
Building entry All Entering the building, requires ID card
so that each process is only listed once but it picks up the Description field with the most information ie has more text in it. As far as I can see no process has more than 2 entries, there are a lot of entries though where there's just one entry. How do I merge these records and remove duplicates?