Remove Duplicates in a cell Append formula

[Danny54]

Is there a quick way to remove duplicates in a append formula?

When I insert the formula in column E I get duplicates.
=A1 & ", " & B1 & ", " & C1

I would like for column E to show Blue,Red for row 1 and Blue,Red,Green for row 2 thus removing the duplicates

Thanks

 

[Fluff]

But here are the results I received:

A8 does not have a space after the comma, hence my solution didn't work. Also you solution will only return the first value from each cell, try changing C8 to Green & you will see the Red disappears from the result

 

[dreid1011]

A8 does not have a space after the comma, hence my solution didn't work. Also you solution will only return the first value from each cell, try changing C8 to Green & you will see the Red disappears from the result

The sample in #6 also did not have a space after the comma.

And thank you for the clarification about the formula.

 

[Fluff]

The sample in #6 also did not have a space after the comma.

Missed that.
So the formula should be

=TEXTJOIN(", ",,UNIQUE(REDUCE(A8,B8:C8,LAMBDA(x,y,TRIM(HSTACK(TEXTSPLIT(x,","),TEXTSPLIT(y,","))))),1))

 

[Danny54]

I'm unfamiliar with XL2BB

Day1	Day2	Day3		Output Without Dupes
Red	Blue	Green		Red,Blue,Green
Red	Green,Blue,Orange	Orange		Red,Green,Blue,Orange
Red	Green			Red,Green
		Brown,Brown,Green		Brown,Green
Black	Yellow,Lite-Green			Black,Yellow,Lite-Green
Magenta		Cyan		Magenta,Cyan

 

[Fluff]

Have you tried the formula in post#13?
As dreid1011 pointed out, I had missed the fact there was no space after the comma.

 

[Danny54]

Yes, trying post #13 i receive a #value error

Day1	Day2	Day3		Day1, Day2, Day3
Red	Blue	Green		Red, Blue, Green
Red	Green,Blue,Orange	Orange		Red, Green, Blue, Orange
Red	Green			#VALUE!​
		Brown,Brown,Green		#VALUE!​
Black	Yellow,Lite-Green			#VALUE!​
Magenta		Cyan		#VALUE!​

 

[Fluff]

That's because you have blank cells, which you never showed before.
Try

=TEXTJOIN(", ",,UNIQUE(REDUCE(A1,B1:C1,LAMBDA(x,y,TRIM(HSTACK(IF(x="","",TEXTSPLIT(x,",")),IF(y="","",TEXTSPLIT(y,",")))))),1))

 

[Danny54]

Sweet,

the solution is perfect #17. Thanks so much!

 

[Fluff]

Glad we could help & thanks for the feedback.