回複：data transformation

來源: pivote 於 2003-11-01 20:06:00 [] [舊帖] [給我悄悄話] 閱讀數 : (414 bytes)
本文內容已被 [ pivote ] 在 2004-02-06 15:24:48 編輯過。如有問題，請報告版主或論壇管理刪除.

tested for you:
x1, x2, x3, x4, x5
y1, y2, y3, y4, y5

Step-1
High light to select data set to pivote
Data | Pivote table and Pivote Chart Wizard ...
follow wizard instruction, drag and drop

Step-2
Replace X1, X2 ... with household 1, household 2 ...

If you have a larger data set or frequent tasks
to do so, it is better to load data into SQL server
(or free MSDE).




--文學城www.wenxuecity.com--
請您先登陸，再發跟帖！