group by - SQL columns grouped by one value output in a row -

group by - SQL columns grouped by one value output in a row -

i never heard 1 of friends needs help sql code.

he wants bring table records grouped 1 value in 1 row. in fact don't know how many records there can don't know if possible.

for illustration have table: name | role | place | 1 | place1 b | 2 | place1 c | 3 | place1 d | 1 | place2 e | 2 | place2 f | 3 | place2 g | 1 | place3

now output should like: place | role 1| role 2| role 3| place1 | | b | c | place2 | d | e | f | place3 | g | | |

is there possibility that?

thanks effort!

sql group-by