COMPARE VALUES ACROSS MULTI COLUMN ROW AND EXTRACT UNIQUE DISTINCT

[Melimob]

Hi after some urgent help please.

I have a table and what to extract just the unique distinct values in an end column by row.
I've looked around and couldn't find anything to give me what I need as per below.
Happy to use either Power Query, excel formula or VBA but really struggling with this. Any help would be gratefully received.

	Column A	Column B	Column C	Column D	OUTPUT
Item 1	U4	U7		U4	U4, U7
Item 2		U4	U4		U4
Item 3	U3		U3		U3
Item 4		U2			U2
Item 5	U2			S2 G9	U2, S2 G9
Item 6				check	check

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

BTW, in relation to the urgent nature of your request, please review points 5g & 5h of the Guidelines

 

[Melimob]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

BTW, in relation to the urgent nature of your request, please review points 5g & 5h of the Guidelines

thanks Peter and sorry for that.. have updated my preferences.. I can't edit to remove 'urgent' but will bear in mind for future. many thanks

 

[Peter_SSs]

Thanks for updating.

Try this

22 03 22.xlsm
	A	B	C	D	E	F
1		Column A	Column B	Column C	Column D	OUTPUT
2	Item 1	U4	U7		U4	U4, U7
3	Item 2		U4	U4		U4
4	Item 3	U3		U3		U3
5	Item 4		U2			U2
6	Item 5	U2			S2 G9	U2, S2 G9
7	Item 6				check	check
Unique

Cell Formulas
Range	Formula
F2:F7	F2	=TEXTJOIN(", ",1,UNIQUE(B2:E2,1))

 

[Melimob]

Thanks for updating.

Try this

22 03 22.xlsm
	A	B	C	D	E	F
1		Column A	Column B	Column C	Column D	OUTPUT
2	Item 1	U4	U7		U4	U4, U7
3	Item 2		U4	U4		U4
4	Item 3	U3		U3		U3
5	Item 4		U2			U2
6	Item 5	U2			S2 G9	U2, S2 G9
7	Item 6				check	check
Unique

Cell Formulas
Range	Formula
F2:F7	F2	=TEXTJOIN(", ",1,UNIQUE(B2:E2,1))

Peter - I can't THANK YOU ENOUGH!! this is so cool and works like a charm!! It's exactly what I needed. thank you thank you thank you!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.