What SQL do I need to say, pivot, a table? For example: I have a view that shows multiple rows of one record because it can be called differently:

ID Name
1 abdomen
1 abdominal
1 abdominal aorta

I would like to create a view that looks like:

ID Name 1 Name 2 Name 3
1 abdomen abdominal abdominal aorta

And how to you deal with the variable number of columns?

I am happy if I can just get:

ID Name string
1 abdomen,abdominal,abdominal aorta

Thanks in advance to your help!