Concat only unique values from one column

[isaacv22]

Hello,

I'm trying to Concat only uniques values from column K, however since the values in column K are the combination of values in columns F-I I'd like to concat these as well. For example if Cell K2 is a unique value then I'd like to concat this value to sheet 2 along with the values of cloumns F2-I2 which are the vlues that make the overall value of K2. Below is minisheet to reference.

Thanks,

New GUI.xlsm
	F	G	H	I	J	K
1	Material	Series	Surface	Width	IN/MM	Chain Desc
2	HP	8500	6	24	IN	HP8506-24IN
3	HP	8500	5	18	IN	HP8505-18IN
4	HP	7700	5	24	IN	HP7705-24IN
5	HP	1500	5	24	IN	HP1505-24IN
6	HP	8500	5	18	IN	HP8505-18IN
7	HP	7700	5	24	IN	HP7705-24IN
8	HP	1500	5	24	IN	HP1505-24IN
form

 

[C Moore]

Try starting with this
=TEXTJOIN(", ",TRUE,UNIQUE(range))

 

[isaacv22]

Thanks, I was able to use this formula and run with it so thank you. It's my first time using textjoin in a formula so I wasn't aware of it.