[算表] excel矩陣如何複製左下方的值至右上方?
軟體:excle
版本:2007
我一個矩陣,且是對稱矩陣,對角線皆為1
但是這個對稱矩陣,只有左下方有值
右上方是空的,想請問有沒有快速的方法
可以把左下方的值轉置到右上方去?
謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.109.32.9
推
03/15 17:05, , 1F
03/15 17:05, 1F
→
03/15 17:07, , 2F
03/15 17:07, 2F
→
03/15 17:07, , 3F
03/15 17:07, 3F
→
03/15 17:08, , 4F
03/15 17:08, 4F
推
03/15 17:08, , 5F
03/15 17:08, 5F
→
03/15 17:09, , 6F
03/15 17:09, 6F
→
03/15 17:09, , 7F
03/15 17:09, 7F
→
03/15 17:10, , 8F
03/15 17:10, 8F
→
03/15 17:11, , 9F
03/15 17:11, 9F
→
03/15 17:12, , 10F
03/15 17:12, 10F
→
03/15 17:13, , 11F
03/15 17:13, 11F