put rows together and group by another column

[theJonster]

Hi

Say i have 3 rows and 2 columns

clientid1, details1
clientid1, details2
clientid1, details3

how do i get this result

clientid1, details1 details2 details3

so basically group by client and then add the rows together into one row.

feels like there should be a function for it.

thanks

[ck9663]

Trythis

Happy coding!

-- CK

[theJonster]

ah yes, I have done pivots before.

Thanks