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

[MWon]

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

[oly · Accepted solution]

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

[binuacs]

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

[Qiu]

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