利用WPS表格数据透视表功能进行表格的一二维相互转换

标签:
wps二维转一维it |
分类: WPS应用 |
如图,二维表是一种汇总形式的表格,而一维表是数据形式的表格(一维表是一种非常重要的表格,是关系数据库的原型)
二维表:; R: K) a6 c0 h4 X) e
http://attach.bbs.wps.cn/attachments/forum/201302/02/204722adabtlb0ptlbafdf.png
1 @) q$ P
一维表:
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
http://attach.bbs.wps.cn/attachments/forum/201302/02/204732rtu76to7nr7r8r56.png
http://attach.bbs.wps.cn/attachments/forum/201302/02/204732b1nhnumdu0qqdr6q.png
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
http://attach.bbs.wps.cn/attachments/forum/201302/02/204737fa9ggqdaa2agjdgc.png
http://attach.bbs.wps.cn/attachments/forum/201302/02/2047384qflilllk2k2kkcm.png
http://attach.bbs.wps.cn/attachments/forum/201302/02/2047397vuj7ja7cjuj7p0e.png
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
http://attach.bbs.wps.cn/attachments/forum/201302/02/20474399n5izp6ive3npen.png
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
http://attach.bbs.wps.cn/attachments/forum/201302/02/204746fdurs22rr2dssi5w.png