How to remove duplicates in one column but not a related one?

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

Workflow

Accepted answers

oly

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

EntryUnique.yxmd

All comments

oly

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

EntryUnique.yxmd

binu_acs

@MWon Another way of doing this with the Multi-Row tool

Multi_Row_28_06.yxmd

Qiu

@MWon
We can do something if we can ignore the number of tools. 😁

0629-MWon.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703