Compare data in columns, remove duplicates and return unique values in a new column

[nitiona]

Dear Experts,

Request your support in generating excel formula for below query,

Basically I have excel containing 4 columns, having unique data. I need a formula that can compare data in 4 columns and return only unique values in a new colum with '+' separator, removing any duplicates. Sample screenshot is attached.

 

[SunnyAlv]

Try this

1

=TEXTJOIN("+",,UNIQUE(TRANSPOSE(A2:D2)))

2 (without TEXTJOIN)

=LEFT(CONCAT(TRANSPOSE(UNIQUE(TRANSPOSE(A2:D2)))&"+"),LEN(CONCAT(TRANSPOSE(UNIQUE(TRANSPOSE(A2:D2)))&"+"))-1)

 

[nitiona]

Try this

1

=TEXTJOIN("+",,UNIQUE(TRANSPOSE(A2:D2)))

2 (without TEXTJOIN)

=LEFT(CONCAT(TRANSPOSE(UNIQUE(TRANSPOSE(A2:D2)))&"+"),LEN(CONCAT(TRANSPOSE(UNIQUE(TRANSPOSE(A2:D2)))&"+"))-1)

Hi Same error for both. Please see screenshot for reference.

 

[Peter_SSs]

Yet again cross-posted without a link after final warning
Compare rows, remove duplicates and return unique values in a separate column - OzGrid Free Excel/VBA Help Forum