[算表] 資料排序、轉置

看板Office作者 (帖十六)時間15年前 (2011/06/04 17:04), 編輯推噓1(103)
留言4則, 2人參與, 最新討論串1/2 (看更多)
軟體: excel 版本: 2007 原始資料如下: 欄A 欄B be likely to 有可能 They are not likely to arrive in time. to the full(est) 徹底地 The boys enjoyed the camping trip to the full. . . . a matter of 僅僅 It was just a matter of a few coins. 希望能按片語字母首字排序,並將例句移到欄A,成為: a matter of 僅僅 It was just a matter of a few coins. be likely to 有可能 They are not likely to arrive in time. to the full(est) 徹底地 The boys enjoyed the camping trip to the full. 謝謝。 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 210.66.114.164

06/04 22:50, , 1F
開新的工作表 用offset()
06/04 22:50, 1F

06/04 22:51, , 2F
精華區 z 2 1 1
06/04 22:51, 2F

06/04 23:50, , 3F
看過精華區offset的介紹,但沒找到符合的狀況,能否給多一
06/04 23:50, 3F

06/04 23:50, , 4F
點線索,謝謝
06/04 23:50, 4F
文章代碼(AID): #1DwVKh3e (Office)
討論串 (同標題文章)
文章代碼(AID): #1DwVKh3e (Office)