'Remove duplicates from columns in Google Sheets

In this link I am trying to demonstrate what I want google sheets to do; remove duplicates from column cells - row by row.

I've tried removing duplicates from cells, and by row, but haven't had any luck with removing them by column.

This is a pretty big database (2k+ entries), so really hoping to find a clean solution by putting this question out to the community.

Solution 1:^[1]

paste in G2:

={A3:A, ARRAYFORMULA(REGEXREPLACE(B3:E, A3:A, ))}

=ARRAYFORMULA(A3:A) in G3 (or =UNIQUE(A3:A) if what is in the red frame is not ok).

And this in H3:

=ARRAYFORMULA(IF(IFERROR(MATCH(B3:E, A3:A, 0), 0) <> 0, "", B3:E))

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	player0
Solution 2	kishkin