如图,二维表是一种汇总形式的表格，而一维表是数据形式的表格（一维表是一种非常重要的表格，是关系数据库的原型）
二维表:; R: K) a6 c0 h4 X) e
http://attach.bbs.wps.cn/attachments/forum/201302/02/204722adabtlb0ptlbafdf.png 
1 @) q$ P  t1 a: |3 o# Y
一维表:
http://attach.bbs.wps.cn/attachments/forum/201302/02/204726hp0e0hhy8eob28zg.png 
; d. b$ J6 h& C8 w# D
1.二维表转换成一维表# V5 O7 Q# h4 d/ [* H
http://attach.bbs.wps.cn/attachments/forum/201302/02/20472727lb0prfz72r5jzj.png 1 O& q0 t, S- I) ?
http://attach.bbs.wps.cn/attachments/forum/201302/02/204732rtu76to7nr7r8r56.png 
http://attach.bbs.wps.cn/attachments/forum/201302/02/204732b1nhnumdu0qqdr6q.png . g- x/ C4 \, M
http://attach.bbs.wps.cn/attachments/forum/201302/02/204734ou0jwf2zjosk40h6.png 
http://attach.bbs.wps.cn/attachments/forum/201302/02/204734np4tfusv44fptsrs.png 
http://attach.bbs.wps.cn/attachments/forum/201302/02/204735z129p139obbbj2t1.png " P7 f$ \+ U2 i5 |
http://attach.bbs.wps.cn/attachments/forum/201302/02/204737fa9ggqdaa2agjdgc.png 4 r6 Y( X* i& @/ n" I, \- v0 R
http://attach.bbs.wps.cn/attachments/forum/201302/02/2047384qflilllk2k2kkcm.png 
http://attach.bbs.wps.cn/attachments/forum/201302/02/2047397vuj7ja7cjuj7p0e.png 1 j6 Z9 \. |- y) n. [$ ~% M4 }) N
http://attach.bbs.wps.cn/attachments/forum/201302/02/204739vslz6ehumlzhelm3.png 
http://attach.bbs.wps.cn/attachments/forum/201302/02/204740f9xwlg4w9g4kl4zk.png 
2.一维表转换成二维表
http://attach.bbs.wps.cn/attachments/forum/201302/02/204741jwdtf6ovk29686r6.png % [: z; l+ u5 t1 A7 f6 K+ d, R$ V
http://attach.bbs.wps.cn/attachments/forum/201302/02/20474399n5izp6ive3npen.png 2 ?2 r. r0 A9 X1 i* O0 o# V: R
http://attach.bbs.wps.cn/attachments/forum/201302/02/204744hvee13000dzzmvh3.png 
http://attach.bbs.wps.cn/attachments/forum/201302/02/204744ep5qpqure3rri7op.png 
http://attach.bbs.wps.cn/attachments/forum/201302/02/204745f44cnsak4pi4csg0.png 6 z8 V# z# T+ ^; M5 H
http://attach.bbs.wps.cn/attachments/forum/201302/02/204746fdurs22rr2dssi5w.png 

转载于：http://bbs.wps.cn/thread-22359250-1-1.html