天气预报 > 其他 > 如何把二维表转成一维表
如何把二维表转成一维表
更新时间: 2020-11-19 00:00:00  

数据透视表除了能将一维表转成二维表,同样也可以二维表转成一维表。看如何用透视表将以下二维表转成一维表。

工具/原料EXCEL2007方法/步骤1首先按快捷键ALT+D、P调出数据透视表和透视图向导,选择“多重合并计算数据区域”“数据透视表”,点击下一步

2选择创建”单页字段“,点击下一步

3选定区域,添加,点击下一步

4选择新建图表的位置,选择新建工作表或者在现工作表内选定一个位置,点击下一步

5出现的依然是一张二维表

6将“行”“列”的√去掉,双击A4单元格,即出现一张一维表。

关键词: 如何

如何把二维表转成一维表相关经验

天气预报

最新推荐

页面:/news/view-2906555/ | 耗时:0.3028 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=2906555 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2906555 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2906555 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(131150,1887173,1128675,1357599,1066404,2159394,3434746,1105035,1093601,2683582,2252819,1056732,232773,1064271,276616,1129355,1125401,1276260,1123835,1320779,125904,3088548,1104335,1098809,1062250,1124951,1459063,1127027,1130472,1124396) ORDER BY field (ArticleID,131150,1887173,1128675,1357599,1066404,2159394,3434746,1105035,1093601,2683582,2252819,1056732,232773,1064271,276616,1129355,1125401,1276260,1123835,1320779,125904,3088548,1104335,1098809,1062250,1124951,1459063,1127027,1130472,1124396)