How to delete duplicates in two columns

TheWeetek 

There are a few different ways to do this depending on if you go the text-manipulation route or not.  Ideally, BYROW would be able to handle this, but it's limited to returning scalars.

This is my solution:

=LET(
    rows, ROWS(data),
    columns, COLUMNS(data),
    shuffle, LAMBDA(r, c, SMALL(INDEX(data, r, {1, 2}), c)),
    ordered, MAKEARRAY(rows, columns, shuffle),
    UNIQUE(ordered)
)