Sorry if this is covered elsewhere in another question, but I can't find any examples which exactly match what I need and I'm getting confused.
I have data in the table like this :-
Name | Value
---------------
John | Dog
John | Cat
John | Fish
Bob | Python
Bob | Camel
And I would like the data like this....
Name | Value_1 | Value_2 | Value_3
-------------------------------------
John | Dog | Cat | Fish
Bob | Python | Camel | NULL
I don't want to use case statements because the dog, cat, fish etc there are 20+ possible values and they could change overtime.
Anyone got any pointers?