In my table duplicated ID value is their,that's reason,
ID Name Job DeptName Loc
1 a Mgr sales USA
1 a xxx ffff UK
I want to display data like below
I want this type of output,database values
Can you give me the code for this,How can i start?