我有如下示例数据。

Key KeyName CustomerName  CID      Role

1   K1      Ram           C1       Main
1   K1      Laxman        C5       Child
2   K2      Shyam         C2       Main
3   K3      Ram           C1       Main
4   K4      Shyam Bothe   C2       Main 
5   K5      berry         C3       Child
6   K6      berry Ping    C3       Main

同一客户存在于多个密钥中。我要按以下顺序对重复的客户进行排序。

Key KeyName CustomerName  CID      Role

1   K1      Ram           C1       Main
1   K1      Laxman        C5       Child
3   K3      Ram           C1       Main
2   K2      Shyam         C2       Main
4   K4      Shyam Bothe   C2       Main 
5   K5      berry         C3       Child
6   K6      berry Ping    C3       Main