Hello , following is my table data :
EmployeeDetailID Name AbsentDays Month
3 Vishal Patel 1 May-13
3 Vishal Patel 3 Jun-13
3 Vishal Patel 4 Jul-13
Now i want this data to be converted like below :
EmployeeDetailID Name May-13 Jun-13 Jul-13
3 Vishal Patel 1 3 4
Please help me out with the query and thnx in advance