Suppose, I have An Excel Matrix like below :
EmpId Empname EmpAddrs Hiredate joiningdate Salary TypeOfWorker BondOver CurrentBU reporting officer Manager
11 abc eee 12/10 01/11 20K "P" Yes ALP MM PMO
12 abc tpt 10/10 01/11 10K "T" No ATP MM PMO
82 abc tpp 08/10 01/11 10K "T" No ATP MM OOP
72 abc tpp 08/10 01/11 10K "P" No ATT MM OOP
I Need to merge them all as below:
Manager EmpId Hiredate TypeOfWorker CurrentBU reporting officer EmpId Hiredate TypeOfWorker CurrentBU reporting officer
PMO 11 12/10 "P" ALP MM 12 10/10 "T" ATP MM
OOP 82 08/10 "T" ATP MM 82 08/10 "P" ATT MM
Any Idea to implement the same? All employees having the same manager will be in one row with limited column values.
Thanks
See Question&Answers more detail:os