How to leave only unique entries in the list?

Question

Notepad++

There is a list of IP addresses and some text after each address:
127.0.0.1 blabla
127.0.0.1AAA
127.0.0.1AAB
127.0.0.2 trulala
127.0.0.3 AAAA
127.0.0.3 AAAB
127.0.0.3 AAAC
127.0.0.4 blalba
From this list I need leave only lines with unique IP addresses, that is, they should only remain:
127.0.0.2 trulala
127.0.0.4 blalba
How/how can this be done other than manually? Notepad++ can be used somehow?

Answer 1

Excel :
1) "Text by columns", separator "space"
2) enter a column with the formula IF, which is equal to 1 if the previous or subsequent IP is the same as the current, or equal to 0 otherwise
3) do "Paste Special" / "Values" over this column so that the formulas turn into values
​​4) sort by this column
As a result, only zeros, that is, those you are looking for, will go up.
Then, if necessary, add a column with the CONCATENATE formula to restore the original IP-space-text