sorry I think I should be more specific,, the function that I'm using Im using it from 3 diferent fields, here is the example of the function and some of the information that I'm trying to concatenated
Order# product# Carrier Tracking number
123 a B 123...
Hi
Sorry I'm new on this, I use the same function, and I use the "SELECT DISTINCT " but instead of deliting the reow that is duplicated it add the infromation, for example
colum a colum b
a 1
b 2
a 2
the result shold be
column a column b
a...