[問題] 二維矩陣轉資料格式已回收
請問如果要將二維矩陣
j
如 1 2 3 4 5
i1 1 2 3 4 5
2 5 6 7 8 9
3 7 8 9 1 2
轉換成
j i N
1 1 1
2 1 2
3 1 3
4 1 4
5 1 5
1 2 5
2 2 6
.
.
要如何以這樣的格式輸出到excel上,謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.112.46.33
→
10/08 22:38, , 1F
10/08 22:38, 1F
→
10/09 12:16, , 2F
10/09 12:16, 2F
→
10/09 12:16, , 3F
10/09 12:16, 3F
→
10/09 12:17, , 4F
10/09 12:17, 4F
→
10/11 11:14, , 5F
10/11 11:14, 5F
→
10/11 11:15, , 6F
10/11 11:15, 6F
→
10/18 22:00, , 7F
10/18 22:00, 7F