Return all Unique Values in a Single Cell with col headings

[gavcol]

Hi,

Similar to this thread (Return all Unique Values Based on Criteria in a Single Cell).

I've modified the formula to suit the first table below but I wanted to include the column headings in brackets for each found occurrence as it appears in the example in the 2nd table below.
Is this possible with a formula (not Vb) ?

Thx in advance
Gav

Book1
	A	B	C	D	E	F	G
1	Acct	Desc1	Desc2	Desc3	Desc4	Desc5	Unique
2	AAA111	Start	Start		Begin	First	Start|Begin|First
3	BBB222	Finish	End	Last		Last	Finish|End|Last
Sheet1

Cell Formulas
Range	Formula
G2:G3	G2	=TEXTJOIN("|",TRUE,UNIQUE(B2:F2,TRUE))

Acct	Desc1	Desc2	Desc3	Desc4	Desc5	Unique
AAA111	Start	Start		Begin	First	Start(Desc1, Desc2)|Begin(Desc4)|First(Desc5)
BBB222	Finish	End	Last		Last	Finish(Desc1)|End(Desc2)|Last(Desc3, Desc4)

 

[StephenCrump]

Try G2: =TEXTJOIN("|",1,UNIQUE(BYCOL(B2:F2,LAMBDA(c,IF(c="","",c&"("&TEXTJOIN(", ",1,IF(B2:F2=c,B$1:F$1,""))&")"))),1))

 

[gavcol]

Try G2: =TEXTJOIN("|",1,UNIQUE(BYCOL(B2:F2,LAMBDA(c,IF(c="","",c&"("&TEXTJOIN(", ",1,IF(B2:F2=c,B$1:F$1,""))&")"))),1))

Perfect !!
Thank you.

I keep forgetting about LAMBDA. I really should try to incorporate that a bit more often and get used to using it and thinking of it as a solution.
Cheers
Gav