list of duplicate code along with unique manager name want to split unique

Hi,

Please find below mentioned my problem,

Eg:
Code manager name
1 a
1 b
2 a
2 c
3 d
3 a
4 e
4 a
5 f
5 d
6 w
6 a

want to insert two column as manager1 & 2 and insert unique value codewise.

Regards
Ritesh