[算表] 怎麼把中間被空白分割的數據轉換成另外一欄？

看板Office作者geofran (堯堯)時間12年前 (2013/10/04 21:28)推噓0(0推 0噓 2→)

留言2則, 2人參與討論串1/1

軟體: EXCEL 版本: OFFICE 2010 如下的資料： http://ppt.cc/aJv7 可是貼上到EXCEL上只出現直的一個欄位： 1995 3,704 3,136 46.6 287 119 168 1,204 --- 2,413 1996 3,700 3,048 44.6 289 117 172 1,190 --- 2,422 1997 3,714 2,953 42.2 297 121 176 1,196 --- 2,427 1998 3,732 2,921 41.1 300 122 178 1,176 --- 2,464 1999 3,804 2,927 40.0 301 123 178 1,175 --- 2,534 2000 3,836 2,868 38.5 301 121 180 1,128 --- 2,613 2001 3,945 2,880 39.4 309 126 183 1,091 --- 2,726 2002 4,120 2,866 38.5 283 108 175 1,112 --- 2,866 2003 4,185 2,908 38.4 206 60 146 1,111 --- 2,920 2004 4,317 2,971 37.8 260 98 162 1,117 --- 3,042 2005 4,335 2,992 37.0 255 82 173 1,034 --- 3,135 2006 4,500 2,985 36.0 75 16 59 995 --- 3,293 2007 4,574 3,027 35.8 71 15 56 982 --- 3,376 2008 4,663 3,043 36.1 60 14 46 959 --- 3,488 2009 4,759 3,178 37.8 43 12 31 947 --- 3,595 2010 4,924 3,217 37,3 43 13 30 --- 890 3,818 2011 5,042 3,322 34.8 67 37 889 3,891 請問：如果要把以上數據貼成兩欄以上的表格需要使用到什麼功能？如何可以把中間空白的欄位變成格線？謝謝 -- I don't want to be God, live in infinity, or bosom the world. The glory that belong to human is enough to me, and that's what I pray for. I'm an ordinary people, so I just need the mortal happiness. -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 118.168.121.171