[算表] 資料大量轉置
軟體:excel
版本:2003
我有一個資料表,他的格式大概是這樣的
A 10:00
A 12:00
A 15:00
A 17:00
B 10:00
B 12:05
B 15:14
B 17:01
現在我要把資料弄成
A 10:00 12:00 15:00 17:00
B 10:00 12:05 15:14 17:01
不知道有沒有比較快的方法,我用滑鼠一直貼上轉置好麻煩囧
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.125.78.249
推
09/16 13:29, , 1F
09/16 13:29, 1F
推
09/16 22:37, , 2F
09/16 22:37, 2F
→
09/16 22:37, , 3F
09/16 22:37, 3F
→
09/17 09:51, , 4F
09/17 09:51, 4F
推
09/17 13:52, , 5F
09/17 13:52, 5F
→
09/17 15:09, , 6F
09/17 15:09, 6F
→
09/17 15:10, , 7F
09/17 15:10, 7F
→
12/24 15:50, , 8F
12/24 15:50, 8F
→
12/24 15:50, , 9F
12/24 15:50, 9F
討論串 (同標題文章)