Excel数据透视表，逆透视技巧，1分钟学会！
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>举个工作实例，左边是员工姓名，<span style="color: black;">分部</span>，月份，工资数据，<span style="color: black;">咱们</span>想从左边汇总从右边的样式：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/101084699c13480a9bdc899aa3a7205f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977935&x-signature=Ye5JyBE276jzd8PwvPQxwg%2FkvXw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1、数据透视表过程</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">很<span style="color: black;">显著</span>，<span style="color: black;">咱们</span><span style="color: black;">晓得</span><span style="color: black;">插进</span>数据透视表<span style="color: black;">能够</span>快速完成：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">只需要<span style="color: black;">插进</span>数据透视表之后，将姓名和<span style="color: black;">分部</span>字段放在行标签，将月份放在列标签，将工资字段放在值里面</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>设置以表格样式展示，取消<span style="color: black;">归类</span>汇总，就<span style="color: black;">能够</span>得到如下所示的结果</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/60abb73ca0eb402f93c49bb665439d21~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977935&x-signature=1%2BVMpAELgg%2BVRGtdnqIuHy4rojg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2、数据透视表逆过程</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">那<span style="color: black;">倘若</span>说，<span style="color: black;">咱们</span><span style="color: black;">已然</span>有了右边的数据，<span style="color: black;">期盼</span>转换成左边的格式呢？</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ecf9530c055f4a47838786d9ae47faef~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977935&x-signature=wWvJniTU%2FueFIpKB3fot9SJmeSk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这个过程<span style="color: black;">便是</span>透视表的逆透视，工作中经常需要转换</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>借助Excel的powerquery功能，<span style="color: black;">能够</span><span style="color: black;">容易</span>搞定</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">首要</span>，<span style="color: black;">咱们</span>选中数据区域A1:E5，<span style="color: black;">而后</span>在数据选项卡下，点击来自表格/区域</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/328d8ac106b74e0e9cd8b96b986ed613~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977935&x-signature=Sv5PILia%2F%2FZc%2BV5aaSa2rCaRdQ4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在弹出的创建表里面，直接点击确定：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5b5fd45d4d3c4c0491538741d20ab027~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977935&x-signature=Jctl8T7PWW7nj8eVogroZz4ZzWM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>会来到Powerquery的窗口，简<span style="color: black;">叫作</span>PQ</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>选中<span style="color: black;">第1</span>列，按住SHITE，选中第二列，<span style="color: black;">这般</span>就<span style="color: black;">能够</span>前两列给选中</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>在转换里面，<span style="color: black;">选取</span>逆透视列的下拉选项，<span style="color: black;">选取</span>逆透视其他列</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c32c7bd9194048a0a1dc3cfbffa19cd8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977935&x-signature=idFgAG0KJe2MZlwJa0RRykHIZJA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">一次性就完<span style="color: black;">成为了</span>，最后<span style="color: black;">咱们</span>把数据加载回Excel里面，就<span style="color: black;">能够</span>了</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击左上角的文件，关闭并上载</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f5fe0cd34f074b0186187698d14c52f2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977935&x-signature=Pd%2BL92ctbXBHaV6JeFAFkVcFAp8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>它就会自动创建一个新的工作表，里面的内容<span style="color: black;">便是</span>逆透视的结果</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/049fc4b0e34d46dab24cb322a70b56ac~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977935&x-signature=00YrFa8pWu9J6G4I7GXEayZxReA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">是不是非常简单又好用</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">下次遇到数据需要逆透视的时候，用起来吧！</p>
你的话深深触动了我，仿佛说出了我心里的声音。 论坛外链网http://www.fok120.com/ 我深受你的启发，你的话语是我前进的动力。
页:
[1]