Remove duplicates in rows, not columns

[FlashDota]

Hello,
I am trying to remove duplicates going through rows, but the only option I can find on Excel is removing them from each column. Is there a way to achieve this either with a formula or using VBA?

i.e from the picture:
Row 1 - delete nothing
Row 2 - delete the "B" and bring two "A"s near each other
Row 3 - delete the "A"

 

[DanteAmor]

In cel E1 and copy down:

=LET(a,A1:C1,IF(COUNTA(UNIQUE(a,TRUE))<COUNTA(a),FILTER(a,COUNTIF(a,a)>1),a))

 

[Joe4]

Hello,
I am trying to remove duplicates going through rows, but the only option I can find on Excel is removing them from each column. Is there a way to achieve this either with a formula or using VBA?

i.e from the picture:
Row 1 - delete nothing
Row 2 - delete the "B" and bring two "A"s near each other
Row 3 - delete the "A"

View attachment 93597

Your question does not make much sense to me.
Are you trying to remove the duplicates, or leave the duplicates?
Also, there is now "B" in Row 2. Perhaps you are mixing up your words, and really mean "Column" where you have written "Row"?

It would helpful if you showed us what your expected output of your example should be.