[算表] 如何用EXCEL自動插入?
軟體:EXCEL
版本:2013
[程式問題]:這是個有關資料整理的問題
原始資料如下
Company StartYear EndYear President
---------------------------------------
APPLE 2002/2/3 2005/3/3 John
APPLE 2005/3/4 2006/12/3 Amy
GOOGLE 2001/1/9 2003/8/7 Ken
GOOGLE 2007/8/8 2009/3/7 Mary
我想將table整理成
Company Year President
---------------------------------------
APPLE 2002 John
APPLE 2003 John
APPLE 2004 John
APPLE 2005 John
APPLE 2005 Amy
APPLE 2006 Amy
GOOGLE 2001 Ken
GOOGLE 2002 Ken
GOOGLE 2003 Ken
GOOGLE 2007 Mary
GOOGLE 2008 Mary
GOOGLE 2009 Mary
目前最大的問題是:
不知如何用EXCEL自動補YEAR
(若有前輩知道如何用SAS解決此問題,也請不吝指教>"<)
我的初步想法是用EndYear減StartYear=x
for i=1 to x
做插入Year的動作(插入下一年的Year值)
想請各位前輩幫忙>"< 感激不盡
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 140.119.120.6
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1425564346.A.2B1.html
→
03/06 01:02, , 1F
03/06 01:02, 1F
→
03/06 01:44, , 2F
03/06 01:44, 2F
→
03/06 01:45, , 3F
03/06 01:45, 3F
→
03/06 02:00, , 4F
03/06 02:00, 4F
※ 編輯: faceoflove56 (140.119.143.76), 03/06/2015 02:00:58
→
03/06 02:03, , 5F
03/06 02:03, 5F
→
03/06 08:31, , 6F
03/06 08:31, 6F
→
03/06 08:32, , 7F
03/06 08:32, 7F
→
03/06 08:33, , 8F
03/06 08:33, 8F
→
03/06 08:34, , 9F
03/06 08:34, 9F
→
03/06 08:35, , 10F
03/06 08:35, 10F
※ 編輯: faceoflove56 (140.119.143.76), 03/06/2015 08:37:15
→
03/06 08:43, , 11F
03/06 08:43, 11F
→
03/06 08:45, , 12F
03/06 08:45, 12F
→
03/06 08:47, , 13F
03/06 08:47, 13F
→
03/06 10:30, , 14F
03/06 10:30, 14F
→
03/06 10:30, , 15F
03/06 10:30, 15F
→
03/06 10:43, , 16F
03/06 10:43, 16F
→
03/06 10:48, , 17F
03/06 10:48, 17F
→
03/06 10:49, , 18F
03/06 10:49, 18F
→
03/06 10:49, , 19F
03/06 10:49, 19F
→
03/06 10:51, , 20F
03/06 10:51, 20F
→
03/06 10:52, , 21F
03/06 10:52, 21F
→
03/06 10:52, , 22F
03/06 10:52, 22F
→
03/06 11:12, , 23F
03/06 11:12, 23F
→
03/06 11:12, , 24F
03/06 11:12, 24F
→
03/06 12:51, , 25F
03/06 12:51, 25F
→
03/06 13:07, , 26F
03/06 13:07, 26F
→
03/06 13:21, , 27F
03/06 13:21, 27F