说明-第一个表是原始表，在下一行中粘贴唯一名称(加里，本)作为转置，在下面的单元格中插入索引匹配公式，然后向下拖动，在下一列中编写类似的公式然后向下拖动.

Explanation - First table is the original table, paste unique names ( Gary, Ben) as transpose in the next rows , insert the index match formula in cell below and drag down,write similar formula in next column and drag down.

使用此公式INDEX($ C:$ C，MATCH(F $ 2，$ A:$ A，0)+ ROW(1:1)-1,0)或查找偏移量公式.C列包含金色，银色细节，a列包含名称.F2将gary粘贴为下面的转置

use this formula INDEX($C:$C,MATCH(F$2,$A:$A,0)+ROW(1:1)-1,0) or look for offset formula. Column C contains gold,silver detail and column a contains names. F2 is gary pasted as transpose below

Gary    Ben [ transpose of all unique names]
formula formula
formula formula

然后复制粘贴表e:f作为转置值以获得所需的布局

Then copy paste table e:f as transpose values to get the desired layout