改变一下原始数据的排列将数据放在a1:e9如下(其中[]代表空单元格)[] A B C D甲 1 5 [] [][] [] [] 10 14乙 2 6 [] [][] [] [] 11 15丙 3 7 [] [][] [] [] 12 16丁 4 8 [] [][] [] [] 13 17