P
Pritesh
I have huge data containing running project details, wherein I need to
list-out Names of Projects under various Managers. So a manager can have 1 or
2 or 10 projects under him.
Pls suggest me solution/formula based on below output requirement.
Example Input:
A B
1 Mngr1 Proj1
2 Mngr2 Proj3
3 Mngr1 Proj2
4 Mngr1 Proj5
5 Mngr2 Proj4
Example- Reqd Output:
A B
1 Mngr1 Proj1
2 Mngr1 Proj2
3 Mngr1 Proj5
4
5 Mngr2 Proj3
6 Mngr2 Proj4
7
Regards,
Pritesh
list-out Names of Projects under various Managers. So a manager can have 1 or
2 or 10 projects under him.
Pls suggest me solution/formula based on below output requirement.
Example Input:
A B
1 Mngr1 Proj1
2 Mngr2 Proj3
3 Mngr1 Proj2
4 Mngr1 Proj5
5 Mngr2 Proj4
Example- Reqd Output:
A B
1 Mngr1 Proj1
2 Mngr1 Proj2
3 Mngr1 Proj5
4
5 Mngr2 Proj3
6 Mngr2 Proj4
7
Regards,
Pritesh