Excel 统计一列中相同多行的平均值

1) Select all data
2) Insert PivotTable
3) Select Field
a) "One Colunm" to Row Labels
b) "Another Colunm" Move to Values, and Value Field Settings to "Average"