Hi there,
i want to the following to happen. dont know how to achieve it.
eg
result of a query;
ID Name
1 Jan
1 Harry
1 Tim
2 Lim
2 John
i want to put this in a table as
ID Name1 Name2 Name3
1 Jan Harry Tim
2 Lim John
couldnt put this in a better way. Hope it makes sense
Thanks