创建两个新列Supervisor和Administrator，并运行两个查询，一个用于更新主管，如

UPDATE table SET supervisor = name where role='supervisor'

第二步更新admin

UPDATE table SET admin = name where role ='admin'

如果你只需要数据检索，而不需要改变表结构，那么一个简单的条件聚合就可以了。
对于给定的数据示例，

CREATE TABLE `contacts` (
  ClientName varchar(10),
  Role varchar(15),
  Name varchar(15)
) ;
insert into contacts values ('A123','Supervisor','Dave1'),
('A123','Administrator','Dave2'), ('Q012','Supervisor','Jane2'),
('Q012','Administrator','Kent3');

查询

select ClientName,
       max(case when role='Supervisor' then Name end) as Supervisor,
       max(case when role='Administrator' then Name end) as Administrator
from contacts
group by ClientName;

结果

ClientName  Supervisor  Administrator
   A123       Dave1        Dave2
   Q012       Jane2        Kent3

如果您想更改表结构。使用单个事务创建一个临时表，将数据存储在临时表中，然后更改结构并将数据插入回主表。
我已经考虑到你正在使用InnoDB存储引擎。

SET autocommit=0;
LOCK TABLES contacts WRITE;
### Create a temporary table to insert the data from the main table
create temporary table temp_myTable (
  ClientName varchar(10),
  Supervisor varchar(15),
  Administrator varchar(15)
  );
##### Insert unique data to the temporary table
insert into temp_myTable 
 select ClientName,
       max(case when role='Supervisor' then Name end) as Supervisor,
       max(case when role='Administrator' then Name end) as Administrator
from contacts
group by ClientName;
##### Delete all data from main table
truncate contacts;
#####Change  contacts structure 
ALTER TABLE contacts 
  drop column Role,
  drop column Name,
  add column Supervisor varchar(15),
  add column Administrator varchar(15);
###### Insert data to the main table
INSERT INTO contacts  SELECT * FROM temp_myTable;
########### Delete the created temprary table
drop temporary table temp_myTable;
COMMIT;
UNLOCK TABLES;

See example