guptaalok12 0 Light Poster

Emp
-----
ID Name
1 x
1 P
2 y
2 Q
3 W

Emp_Data

Id Name-1 Name-2
1 x P
2 y Q
3 w


above is my tables (Emp ),And the I want the Resulting Data in the (Emp_Data) format.is this possible Pls Help........Thanks in advance-----