软件:Microsoft Excel
版本:2010
name apple bus car dog name
AA aaple-1 bus-1 car-1 dog-1 AA apple apple-1
BB apple-2 bus-2 car-2 dog-2 AA bus bus-1
CC apple-3 bus-3 car-3 dog-3 AA car car-1
DD apple-4 bus-4 car-4 dog-4 AA dog dog-1
EE apple-5 bus-5 car-5 dog-5 BB apple apple-2
BB bus bus-2
BB car car-2
BB dog dog-2
CC apple apple-3
CC bus bus-3
CC car car-3
CC dog dog-3
DD apple apple-4
DD bus bus-4
DD car car-4
DD dog dog-4
EE apple apple-5
EE bus bus-5
EE car car-5
EE dog dog-5
原始资料为左手边，想要整理成右手边
如果数值很多的话，有没有什么办法可以快速达到我想要的排列方式？