[算表] 一維的資料怎麼轉換成二維的顯示呢?
軟體: Excel
版本: 2003
假設 sheet1 有底下資料("軟體名稱"會按照字母順序排列)
(sheet1)
----------------
電腦 軟體名稱
RD-1 A
RD-2 A
RD-3 A
RD-4 A
RD-5 A
RD-6 A
RD-1 B
RD-3 B
RD-5 B
RD-7 B
RD-9 B
RD-2 C
RD-4 C
RD-6 C
RD-8 C
RD-10 C
RD-12 C
RD-14 C
RD-16 C
RD-1 D
RD-2 D
RD-3 D
RD-4 D
RD-5 D
RD-6 D
RD-7 D
RD-8 D
RD-9 D
RD-10 D
RD-11 D
RD-12 D
RD-13 D
RD-14 D
RD-15 D
RD-16 D
RD-17 D
RD-18 D
RD-19 D
RD-20 D
RD-21 D
RD-22 D
RD-23 D
RD-24 D
RD-1 E
RD-2 E
RD-3 E
RD-4 E
RD-5 E
RD-6 E
RD-7 E
----------------
怎麼轉換成
(sheet2)
-----------------------------------------
A B C D E
RD-1 1 1 1 1
RD-2 1 1 1 1
RD-3 1 1 1 1
RD-4 1 1 1 1
RD-5 1 1 1 1
RD-6 1 1 1 1
RD-7 1 1 1
RD-8 1 1
RD-9 1 1
RD-10 1 1
RD-11 1
RD-12 1 1
RD-13 1
RD-14 1 1
RD-15 1
RD-16 1 1
RD-17 1
RD-18 1
RD-19 1
RD-20 1
RD-21 1
RD-22 1
RD-23 1
RD-24 1
-----------------------------------------
請有經驗的鄉民指導一下,
Thank you.
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 122.121.209.5
→
06/27 22:44, , 1F
06/27 22:44, 1F
→
06/27 23:07, , 2F
06/27 23:07, 2F
→
06/27 23:07, , 3F
06/27 23:07, 3F
→
06/28 00:07, , 4F
06/28 00:07, 4F
→
06/28 00:08, , 5F
06/28 00:08, 5F
→
06/28 00:08, , 6F
06/28 00:08, 6F
→
06/29 00:51, , 7F
06/29 00:51, 7F
→
06/29 00:52, , 8F
06/29 00:52, 8F
→
06/29 00:54, , 9F
06/29 00:54, 9F