unique values from a column into one row, each item separated with a comma

[Tommeck37]

Hello,

Can anyone help me with this difficult task?



I am looking for a formula that would select only unique values that are located in next column. The values in next column can be duplicated.
What I need is a copy of each unique value from that column separated by comma in one cell. It can be the last row next to the filled in column.

I have prepared a file how it should look like at the end.

Please find a copy of excel spreadsheet in this location:

https://1drv.ms/x/s!AjQ2afcR5zV7kTLjyqiUzxb7Fgao

I need to emphasize that I need a formula (not vba code).

Many thanks in advance

Tommeck37

 

[Tommeck37]

THANK YOU ALL GUYS IT WORKS FINE.

GREAT MANY THANKS TO YOU!

Tommeck37