How to remove duplicates in one column but not a related one?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a data set that has two columns with related data. However, I've had trouble explaining the issue, so I've included an example below.
Here is what it originally looks like:
EntryA | Unique1 |
EntryA | Unique2 |
EntryA | Unique3 |
EntryA | Unique4 |
And I want to turn it into just this(or something similar that I can work with)
Entry A | Unique 1 |
Unique1 | |
Unique3 | |
Moreover, I still want to maintain the relationship between these two columns, such that I would be able to know that Entry A is still related to Unique1-3, despite the fact that there is only one cell with Entry A in it
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MWon ,
I would create a new column for the Entry Header only requirement and keep the original values on Entry to be able to do other matching/processing.
You need to use MultiRow tool (it's a little tricky, check interactive videos or Youtubes how to use it).
See example attached. Hope it works for you!
Best,
Oly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
