i need to arrange some data which is linked to each other like relatives of a family working in any organization. Experts can guide in this matter will be highly appreciated.

e.g. Riaz Khan has 2 brothers( Sheraz Khan & Asif Khan all have mentioned each other in the system), i need to group/arrange side by side or sort in a single row or as given below presentation.

Original:

Emp.ID
3329
9988
9778
3329
8515
9988
8515		 Name
Riaz Khan
Asif Khan
Amir Nawaz
Riaz Khan
Sheraz Khan
Asif Khan
Sheraz Khan		 Relation
Brother
Brother
Father
Brother
Brother
Brother
Brother		 Rel. EmpID
9988
8515
1677
8515
9988
3329
3329		 Rel Name
Asif Khan
Sheraz Khan
Gul R.
Sheraz Khan
Asif Khan
Riaz Khan
Riaz Khan

The required output:

Emp.ID
3329
3329
8515
8515
9988
9988
9778		 Name
Riaz Khan
Riaz Khan
Sheraz Khan
Sheraz Khan
Asif Khan
Asif Khan
Amir Nawaz		 Relation
Brother
Brother
Brother
Brother
Brother
Brother
Father		 Rel. EmpID
8515
9988
3329
9988
3329
8515
1677		 Rel Name
Sheraz Khan
Asif Khan
Riaz Khan
Asif Khan
Riaz Khan
Sheraz Khan
Gul R.