how to arrange/sort any data value which is linked each other.

[usyusy]

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.

[JohnTopley]

See yellow banner on how to attach a sample file including expected results.

[JohnTopley]

Simply sort by Name and Relation ??

[usyusy]

Simply sort by Name and Relation ??

thanks sir, actually boss asked from us to identify the employees who have and who have not Revealed their relatives disclosures in the organization.
so just have to find links in the Employees IDs who have some relation among them. so if sorting is fulfilling the purpose or any better tips you have, then appreciable.

[usyusy]

any one please

[AliGW]

Unclear. There is nobody in the sample data who does NOT have a relative listed, is there? And the sample result table is no different.

Your sample workbook needs to clearly illustrate what you are trying to achieve - this one does not do that.

Are you still using Excel 2007?