I found a nice piece of code at:
XL-CENTRAL.COM : VBA : List the Unique and Concatenated Corresponding Values
but with the data set I am using it gives me a type missmatch 13 all indicateion is that it crash because of the max element limits of transpose function.
I would like to reduce...