hi,

To add on the above, I have grouped the above two input tables into a single table. So i just want to get the below result froma single table.

Table

1Brand1

2Brand1

3Brand2

3Brand3

3Brand4

3Brand5

Result

1Brand1

2Brand1

3Brand3,Brand4,Brand5

Thanks

Vijay

hi Luis,

I think i should use the STUFF instead of the coalesce here. As coalesce is for returning the non null values. Can you please help me out with the...