[算表] 如何讓我的資料重新排列
軟體: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
原始資料為左手邊，想要整理成右手邊
如果數值很多的話，有沒有什麼辦法可以快速達到我想要的排列方式？
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 1.170.189.233
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1411736306.A.61B.html
→
09/26 21:15, , 1F
09/26 21:15, 1F
→
09/26 21:16, , 2F
09/26 21:16, 2F
→
09/26 21:52, , 3F
09/26 21:52, 3F
→
09/26 21:53, , 4F
09/26 21:53, 4F
→
09/26 21:57, , 5F
09/26 21:57, 5F
→
09/26 22:03, , 6F
09/26 22:03, 6F
→
09/26 22:17, , 7F
09/26 22:17, 7F
→
09/26 22:36, , 8F
09/26 22:36, 8F
→
09/26 22:50, , 9F
09/26 22:50, 9F
→
09/27 08:46, , 10F
09/27 08:46, 10F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
