I am trying to find a way to remove duplicates from a list of values between a column of "have and not have" and includes everything from the original list. I need this to repeat for each set of IDs.

This list would be: A1, B1, C1, D1, E1.

An example of the raw data would be:

```
UniqueID | Have | Not Have
---------------------------
Z12345   | A1   | B1
Z12345   | A1   | C1
Z12345   | A1   | D1
Z12345   | A1   | E1
Y12345   | A1   | D1
Y12345   | B1   | E1
Y12345   | C1   | D1

```

The output I'm trying to get is:

```
UniqueID | Have | Not Have
---------------------------
Z12345   | A1   | B1
Z12345   |      | C1
Z12345   |      | D1
Z12345   |      | E1
Y12345   | A1   | D1
Y12345   | B1   | E1
Y12345   | C1   | 

```

I can't think of any way to approach this. I thought maybe running If statements to check if the IDs are matching and then run an if statement to remove the duplicates, but I couldn't figure out how to run it separately for each set of IDs. Any help or direction on how to approach this would be really appreciated!