Rows to columns

[ersatz]

Hello,
I have a table with 2 columns:

Name SerialNumber
123 4GB6Y78
123 53F7TH
124 4GB6Y78
124 53F7TH
124 53E8BX
the question is :
how to get the results as following:

123 4GB6Y78 53F7TH
124 4GB6Y78 53F7TH 53E8BX
...
125 with 6 columns....
etc...

Thank you very much!

 

[markros]

You're looking into Dynamic Pivot. You can search this forum for samples or google for samples.

PluralSight Learning Library

 

[ersatz]

Hello markros,
Thanks you very much for the hint, I found what I was looking for........ a very good example about Dynamic PIVOT without specifying columns

Thanks again