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