为了使学习场景更加真实，对于3000条数据的联动菜单的调整我单独开了一篇文章做讲解。实际工作当中你很难遇到会有3000条数据甚至更多，在此仅给大家提供两种可能性。
3000条数据设置对应关系.gif
这一步主要是准备工作，方便我们对后面的区域进行指定。那么问题来了，大鹏老师特别的狠，一次性给了3000多条数据，你怎么去批量指定呢？大家以前在网上看到的教程，设置联动菜单的分类和子项都很少，哪怕是累点，手工调整下就可以了，我在基础篇里面也做了讲解方法，根据这个方法去操作就可以很轻松的完成。但是今天大鹏老师给你提供了3000条数据，而且还是三级，你还搞得定吗？下载演示文件，简书私信回复“3”获取密码
理想中的样子.png
-
首先我们拿到的数据是下面的样子
实际我们拿到的源数据是这个样子的.png
-
但是我们需要把内容变成这个样子才能方便去指定。而且还不仅仅是这个几个，而是3000多条，听起来都有点恐怖，但是不用怕。
理想中的样子.png
我们有几个选择：
1、我们可以手工一个一个粘贴过去，如果数据量少这个方法完全没问题；
2、我们可以使用数组公式把数据取过去，但是数组公式不是人人都会的吧？而且计算效率堪忧。
3、使用大鹏老师教你使用数据透视的方法，3000条数据都是小意思。
4、使用Power Query对数据进行处理，而且还很简单。
我们重点讲解后两种方法，我们也可以提前对Power Quer有一个认识。
方法三
这部分内容大部分都是跟普通版是重复的，但是不完全一样，你要是按照普通版的方法去做，你可能做不出来，差异的部分我会点出来。
设置省份
-
我们只需要复制A列，粘贴到E列，并对E列进行去重操作即可得到需要的省份的分类效果。
设置省份.png
省份去重.png
设置省份和城市对应表
1、透视源数据，并且指定一个位置。
数据透视源数据.png
2、选择数据透视字段。将省份放入列、将城市放入行、将城市放入值并计数。
调整字段摆放位置.png
3、调整数据透视页面布局。将当前活动单元格定位到数据透视表区域内任一单元格，点击设计菜单-总计-对行和列禁用。该步骤主要为了消除后续步骤不必要的麻烦。
图片.png
4、将数据透视表复制出来，粘贴为值。并选中图中灰色区域，不要选择首行和首列。
复制数据透视表.png
5、使用快捷键Ctrl+G或者开始菜单-查找和选择-定位条件。如果是使用快捷键则在弹出的界面中选择“定位条件”。选择定位常量并确定，会出现下图的效果。
定位条件.png
定位常量.png
定位效果.png
6、在这个状态下不要做其他操作，直接输入“=$A2”，输入完毕后按下Ctrl+Enter(回车)，即可将数字替换为左侧省份对应的城市。然后全选-复制-粘贴为值，少了这一步，下一步会报错。
输入公式批量填充并复制粘贴为值.png
7、删除A列-全选-定位条件-空值-确定，在灰色区域上右击，选择下方单元格上移并确定。
定位空值.png
最终效果.png
设置城市和区县对应表
方法同设置省份和城市对照表，只是在数据透视时列放入城市，行放入区县，并对区县进行计数。由于城市和区县的数据量较大，在设置城市和区县对应关系的时候Excel会特别卡，尤其是在定位的环节，请耐心等待即可。
警告、警告、警告
你按照上面的方法虽然可做出来很完美的分组，但是你无法创建名称，你会得到下面的错误，那么问题来了，我们之前按照同样的方法设置就没问题，为什么会在这里出现这样一个错误呢？？？
原因我已经在另一篇文章做了详细的讲解，点击查看详情，“此选择无效。请确保复制和粘贴区域不会重叠，除非他们具有相同的大小和形状”，总结起来就是一句话：我们必须按照每列行数从小到大排列。
你做出来市这样的.png
实际应该做成的效果.png
如果做成上图的布局，那么在创建名称时则不会再报错。那我们怎么进行排序呢或者怎么才能实现我们需要达到的效果呢？
我们有三个方案：
1、对从数据透视表复制出来的数据进行转置，然后计数每个标题下有多少个子项然后排序，再转置回来；
2、将现有已经制作好的分组进行转置，按照最左列创建名称；
3、通过Power Query使用辅助列，通过合并查询将每个标题下的子项数量进行拼接然后排序。（该方法会放在方法四中讲解)
1、 当我们在操作到把数据透视表的数据粘贴为值以后，增加一个步骤，使用Ctrl+Shift+*选中连续数据区域，该快捷键不适用于WPS，你也不能全选整个工作表，因为无法无法转置。
将结果粘贴到一个临时表。我们在最后一列新增一个辅助列，对行进行计数，然后按照升序排序(从小到大)，删掉辅助列，继续使用快捷键Ctrl+Shift+*，选中数据连续区域，再到一个临时表转置。后面的步骤就跟原有步骤一样了，你就能做出来一个按照不同列行数大小从小到大的排列布局。
辅助列排序.png
2、我们依然按照原有的方法操作，在最后一步做更改，把分组好的数据使用Ctrl+Shift+*选中后在一个新表进行转置。
在创建名称的时候，选择最左列，这并不影响后续我们制作联动菜单的效果，虽然其他部分都是指定首行，但使用最左列效果也是一样的，最终都是要实现对名称和区域进行创建的目的。
最左列.png
方法三总结：
很显然，方法三足够好，已经可以满足我们的需要了，但是当我们的数据量再次增加，方法三的不足之处就会显露出来，尤其是在定位环节，会特别卡，也就是说方法三支持的数据量其实是有上限的。然后实际工作当中你很难遇到这么极端的情况，这里其实是跟大家提供一种可行的方法。
方法四：
那么我再讲解一下方法四，可以说方法四对数据量么有太多限制，如果比现在的数据还要多那么你就要考虑使用方法四了。方法四使用的是Power Query工具进行操作。很多人对这部分会比较陌生，不过没关系，仅作了解就可以。我对M语言并不是很熟悉，大部分时间都在研究DAX语言，所以无法对大家讲解具体实现原理，关于该功能，参考于施阳老师“Power Query爱好者”，可以点击下面链接查看具体使用教程。
分组转置教程
下面这部分是我根据教程做出分组效果的代码，分享给大家。如果你会使用Power Query可以深入的研究一下。
图片.png
实现省份分组的代码：
let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
更改的类型 = Table.TransformColumnTypes(源,{{"省级名称", type text}, {"市级名称", type text}, {"县级名称", type text}}),
删除的其他列 = Table.SelectColumns(更改的类型,{"省级名称"}),
删除的副本 = Table.Distinct(删除的其他列)
in
删除的副本
实现城市分组的代码：
let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
更改的类型 = Table.TransformColumnTypes(源,{{"省级名称", type text}, {"市级名称", type text}, {"县级名称", type text}}),
删除的其他列 = Table.SelectColumns(更改的类型,{"省级名称", "市级名称"}),
删除的副本 = Table.Distinct(删除的其他列),
分组的行 = Table.Group(删除的副本, {"省级名称"}, {{"市级名称", each _[市级名称]}}),
结果 = Table.FromColumns(分组的行[市级名称],分组的行[省级名称]),
降级的标题 = Table.DemoteHeaders(结果),
更改的类型1 = Table.TransformColumnTypes(降级的标题,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}, {"Column16", type text}, {"Column17", type text}, {"Column18", type text}, {"Column19", type text}, {"Column20", type text}, {"Column21", type text}, {"Column22", type text}, {"Column23", type text}, {"Column24", type text}, {"Column25", type text}, {"Column26", type text}, {"Column27", type text}, {"Column28", type text}, {"Column29", type text}, {"Column30", type text}, {"Column31", type text}}),
转置表 = Table.Transpose(更改的类型1),
合并的查询 = Table.NestedJoin(转置表,{"Column1"},城市辅助,{"省级名称"},"城市辅助",JoinKind.LeftOuter),
#"展开的“城市辅助”" = Table.ExpandTableColumn(合并的查询, "城市辅助", {"计数"}, {"计数"}),
排序的行 = Table.Sort(#"展开的“城市辅助”",{{"计数", Order.Ascending}}),
删除的其他列1 = Table.SelectColumns(排序的行,{"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15", "Column16", "Column17", "Column18", "Column19", "Column20", "Column21", "Column22"}),
转置表1 = Table.Transpose(删除的其他列1),
提升的标题 = Table.PromoteHeaders(转置表1, [PromoteAllScalars=true]),
更改的类型2 = Table.TransformColumnTypes(提升的标题,{{"上海市", type text}, {"天津市", type text}, {"北京市", type text}, {"重庆市", type text}, {"海南省", type text}, {"宁夏回族自治区", type text}, {"西藏自治区", type text}, {"青海省", type text}, {"福建省", type text}, {"吉林省", type text}, {"贵州省", type text}, {"陕西省", type text}, {"山西省", type text}, {"江西省", type text}, {"浙江省", type text}, {"内蒙古自治区", type text}, {"河北省", type text}, {"黑龙江省", type text}, {"江苏省", type text}, {"湖南省", type text}, {"辽宁省", type text}, {"湖北省", type text}, {"广西壮族自治区", type text}, {"甘肃省", type text}, {"新疆维吾尔自治区", type text}, {"云南省", type text}, {"安徽省", type text}, {"山东省", type text}, {"河南省", type text}, {"广东省", type text}, {"四川省", type text}})
in
更改的类型2
111
let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
更改的类型 = Table.TransformColumnTypes(源,{{"省级名称", type text}, {"市级名称", type text}, {"县级名称", type text}}),
删除的其他列 = Table.SelectColumns(更改的类型,{"市级名称", "县级名称"}),
删除的副本 = Table.Distinct(删除的其他列),
分组的行 = Table.Group(删除的副本, {"市级名称"}, {{"县级名称", each _[县级名称]}}),
结果 = Table.FromColumns(分组的行[县级名称],分组的行[市级名称]),
降级的标题 = Table.DemoteHeaders(结果),
更改的类型1 = Table.TransformColumnTypes(降级的标题,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}, {"Column16", type text}, {"Column17", type text}, {"Column18", type text}, {"Column19", type text}, {"Column20", type text}, {"Column21", type text}, {"Column22", type text}, {"Column23", type text}, {"Column24", type text}, {"Column25", type text}, {"Column26", type text}, {"Column27", type text}, {"Column28", type text}, {"Column29", type text}, {"Column30", type text}, {"Column31", type text}, {"Column32", type text}, {"Column33", type text}, {"Column34", type text}, {"Column35", type text}, {"Column36", type text}, {"Column37", type text}, {"Column38", type text}, {"Column39", type text}, {"Column40", type text}, {"Column41", type text}, {"Column42", type text}, {"Column43", type text}, {"Column44", type text}, {"Column45", type text}, {"Column46", type text}, {"Column47", type text}, {"Column48", type text}, {"Column49", type text}, {"Column50", type text}, {"Column51", type text}, {"Column52", type text}, {"Column53", type text}, {"Column54", type text}, {"Column55", type text}, {"Column56", type text}, {"Column57", type text}, {"Column58", type text}, {"Column59", type text}, {"Column60", type text}, {"Column61", type text}, {"Column62", type text}, {"Column63", type text}, {"Column64", type text}, {"Column65", type text}, {"Column66", type text}, {"Column67", type text}, {"Column68", type text}, {"Column69", type text}, {"Column70", type text}, {"Column71", type text}, {"Column72", type text}, {"Column73", type text}, {"Column74", type text}, {"Column75", type text}, {"Column76", type text}, {"Column77", type text}, {"Column78", type text}, {"Column79", type text}, {"Column80", type text}, {"Column81", type text}, {"Column82", type text}, {"Column83", type text}, {"Column84", type text}, {"Column85", type text}, {"Column86", type text}, {"Column87", type text}, {"Column88", type text}, {"Column89", type text}, {"Column90", type text}, {"Column91", type text}, {"Column92", type text}, {"Column93", type text}, {"Column94", type text}, {"Column95", type text}, {"Column96", type text}, {"Column97", type text}, {"Column98", type text}, {"Column99", type text}, {"Column100", type text}, {"Column101", type text}, {"Column102", type text}, {"Column103", type text}, {"Column104", type text}, {"Column105", type text}, {"Column106", type text}, {"Column107", type text}, {"Column108", type text}, {"Column109", type text}, {"Column110", type text}, {"Column111", type text}, {"Column112", type text}, {"Column113", type text}, {"Column114", type text}, {"Column115", type text}, {"Column116", type text}, {"Column117", type text}, {"Column118", type text}, {"Column119", type text}, {"Column120", type text}, {"Column121", type text}, {"Column122", type text}, {"Column123", type text}, {"Column124", type text}, {"Column125", type text}, {"Column126", type text}, {"Column127", type text}, {"Column128", type text}, {"Column129", type text}, {"Column130", type text}, {"Column131", type text}, {"Column132", type text}, {"Column133", type text}, {"Column134", type text}, {"Column135", type text}, {"Column136", type text}, {"Column137", type text}, {"Column138", type text}, {"Column139", type text}, {"Column140", type text}, {"Column141", type text}, {"Column142", type text}, {"Column143", type text}, {"Column144", type text}, {"Column145", type text}, {"Column146", type text}, {"Column147", type text}, {"Column148", type text}, {"Column149", type text}, {"Column150", type text}, {"Column151", type text}, {"Column152", type text}, {"Column153", type text}, {"Column154", type text}, {"Column155", type text}, {"Column156", type text}, {"Column157", type text}, {"Column158", type text}, {"Column159", type text}, {"Column160", type text}, {"Column161", type text}, {"Column162", type text}, {"Column163", type text}, {"Column164", type text}, {"Column165", type text}, {"Column166", type text}, {"Column167", type text}, {"Column168", type text}, {"Column169", type text}, {"Column170", type text}, {"Column171", type text}, {"Column172", type text}, {"Column173", type text}, {"Column174", type text}, {"Column175", type text}, {"Column176", type text}, {"Column177", type text}, {"Column178", type text}, {"Column179", type text}, {"Column180", type text}, {"Column181", type text}, {"Column182", type text}, {"Column183", type text}, {"Column184", type text}, {"Column185", type text}, {"Column186", type text}, {"Column187", type text}, {"Column188", type text}, {"Column189", type text}, {"Column190", type text}, {"Column191", type text}, {"Column192", type text}, {"Column193", type text}, {"Column194", type text}, {"Column195", type text}, {"Column196", type text}, {"Column197", type text}, {"Column198", type text}, {"Column199", type text}, {"Column200", type text}, {"Column201", type text}, {"Column202", type text}, {"Column203", type text}, {"Column204", type text}, {"Column205", type text}, {"Column206", type text}, {"Column207", type text}, {"Column208", type text}, {"Column209", type text}, {"Column210", type text}, {"Column211", type text}, {"Column212", type text}, {"Column213", type text}, {"Column214", type text}, {"Column215", type text}, {"Column216", type text}, {"Column217", type text}, {"Column218", type text}, {"Column219", type text}, {"Column220", type text}, {"Column221", type text}, {"Column222", type text}, {"Column223", type text}, {"Column224", type text}, {"Column225", type text}, {"Column226", type text}, {"Column227", type text}, {"Column228", type text}, {"Column229", type text}, {"Column230", type text}, {"Column231", type text}, {"Column232", type text}, {"Column233", type text}, {"Column234", type text}, {"Column235", type text}, {"Column236", type text}, {"Column237", type text}, {"Column238", type text}, {"Column239", type text}, {"Column240", type text}, {"Column241", type text}, {"Column242", type text}, {"Column243", type text}, {"Column244", type text}, {"Column245", type text}, {"Column246", type text}, {"Column247", type text}, {"Column248", type text}, {"Column249", type text}, {"Column250", type text}, {"Column251", type text}, {"Column252", type text}, {"Column253", type text}, {"Column254", type text}, {"Column255", type text}, {"Column256", type text}, {"Column257", type text}, {"Column258", type text}, {"Column259", type text}, {"Column260", type text}, {"Column261", type text}, {"Column262", type text}, {"Column263", type text}, {"Column264", type text}, {"Column265", type text}, {"Column266", type text}, {"Column267", type text}, {"Column268", type text}, {"Column269", type text}, {"Column270", type text}, {"Column271", type text}, {"Column272", type text}, {"Column273", type text}, {"Column274", type text}, {"Column275", type text}, {"Column276", type text}, {"Column277", type text}, {"Column278", type text}, {"Column279", type text}, {"Column280", type text}, {"Column281", type text}, {"Column282", type text}, {"Column283", type text}, {"Column284", type text}, {"Column285", type text}, {"Column286", type text}, {"Column287", type text}, {"Column288", type text}, {"Column289", type text}, {"Column290", type text}, {"Column291", type text}, {"Column292", type text}, {"Column293", type text}, {"Column294", type text}, {"Column295", type text}, {"Column296", type text}, {"Column297", type text}, {"Column298", type text}, {"Column299", type text}, {"Column300", type text}, {"Column301", type text}, {"Column302", type text}, {"Column303", type text}, {"Column304", type text}, {"Column305", type text}, {"Column306", type text}, {"Column307", type text}, {"Column308", type text}, {"Column309", type text}, {"Column310", type text}, {"Column311", type text}, {"Column312", type text}, {"Column313", type text}, {"Column314", type text}, {"Column315", type text}, {"Column316", type text}, {"Column317", type text}, {"Column318", type text}, {"Column319", type text}, {"Column320", type text}, {"Column321", type text}, {"Column322", type text}, {"Column323", type text}, {"Column324", type text}, {"Column325", type text}, {"Column326", type text}, {"Column327", type text}, {"Column328", type text}, {"Column329", type text}, {"Column330", type text}, {"Column331", type text}, {"Column332", type text}, {"Column333", type text}, {"Column334", type text}, {"Column335", type text}, {"Column336", type text}, {"Column337", type text}, {"Column338", type text}, {"Column339", type text}, {"Column340", type text}}),
转置表 = Table.Transpose(更改的类型1),
合并的查询 = Table.NestedJoin(转置表,{"Column1"},区县辅助,{"市级名称"},"区县辅助",JoinKind.LeftOuter),
#"展开的“区县辅助”" = Table.ExpandTableColumn(合并的查询, "区县辅助", {"计数"}, {"计数"}),
排序的行 = Table.Sort(#"展开的“区县辅助”",{{"计数", Order.Ascending}}),
删除的其他列1 = Table.SelectColumns(排序的行,{"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15", "Column16", "Column17", "Column18", "Column19", "Column20", "Column21", "Column22", "Column23", "Column24", "Column25"}),
转置表1 = Table.Transpose(删除的其他列1),
提升的标题 = Table.PromoteHeaders(转置表1, [PromoteAllScalars=true]),
更改的类型2 = Table.TransformColumnTypes(提升的标题,{{"省直辖县级行政区划(河南)", type text}, {"嘉峪关市", type text}, {"省直辖县级行政区划(河北)", type text}, {"迪庆藏族自治州", type text}, {"阿拉善盟", type text}, {"莱芜市", type text}, {"金昌市", type text}, {"西双版纳傣族自治州", type text}, {"哈密市", type text}, {"大兴安岭地区", type text}, {"吐鲁番市", type text}, {"新余市", type text}, {"黄南藏族自治州", type text}, {"怒江傈僳族自治州", type text}, {"中卫市", type text}, {"资阳市", type text}, {"石嘴山市", type text}, {"乌海市", type text}, {"六盘水市", type text}, {"鹰潭市", type text}, {"鄂州市", type text}, {"省直辖县级行政区划(湖北)", type text}, {"克孜勒苏柯尔克孜自治州", type text}, {"珠海市", type text}, {"随州市", type text}, {"海北藏族自治州", type text}, {"潮州市", type text}, {"博尔塔拉蒙古自治州", type text}, {"舟山市", type text}, {"淮北市", type text}, {"辽源市", type text}, {"铜陵市", type text}, {"七台河市", type text}, {"武威市", type text}, {"张家界市", type text}, {"自治区直辖县级行政区划(新疆)", type text}, {"海西蒙古族藏族自治州", type text}, {"海南藏族自治州", type text}, {"威海市", type text}, {"日照市", type text}, {"北海市", type text}, {"防城港市", type text}, {"阳江市", type text}, {"汕尾市", type text}, {"亳州市", type text}, {"海口市", type text}, {"三亚市", type text}, {"景德镇市", type text}, {"钦州市", type text}, {"池州市", type text}, {"德宏傣族景颇族自治州", type text}, {"铜川市", type text}, {"盘锦市", type text}, {"克拉玛依市", type text}, {"攀枝花市", type text}, {"丽江市", type text}, {"内江市", type text}, {"惠州市", type text}, {"茂名市", type text}, {"保山市", type text}, {"贵港市", type text}, {"阳泉市", type text}, {"云浮市", type text}, {"宿迁市", type text}, {"兴安盟", type text}, {"湖州市", type text}, {"揭阳市", type text}, {"遂宁市", type text}, {"萍乡市", type text}, {"果洛藏族自治州", type text}, {"东营市", type text}, {"佛山市", type text}, {"白城市", type text}, {"松原市", type text}, {"固原市", type text}, {"娄底市", type text}, {"玉树藏族自治州", type text}, {"宿州市", type text}, {"荆门市", type text}, {"白银市", type text}, {"湘潭市", type text}, {"贺州市", type text}, {"漯河市", type text}, {"鹤壁市", type text}, {"巴中市", type text}, {"海东市", type text}, {"吴忠市", type text}, {"莆田市", type text}, {"咸宁市", type text}, {"来宾市", type text}, {"厦门市", type text}, {"三门峡市", type text}, {"深圳市", type text}, {"濮阳市", type text}, {"许昌市", type text}, {"塔城地区", type text}, {"阿勒泰地区", type text}, {"益阳市", type text}, {"黄石市", type text}, {"枣庄市", type text}, {"晋城市", type text}, {"昌吉回族自治州", type text}, {"朔州市", type text}, {"阿里地区", type text}, {"河源市", type text}, {"泰安市", type text}, {"林芝市", type text}, {"自贡市", type text}, {"张掖市", type text}, {"衢州市", type text}, {"黑河市", type text}, {"扬州市", type text}, {"镇江市", type text}, {"本溪市", type text}, {"德阳市", type text}, {"营口市", type text}, {"泰州市", type text}, {"丹东市", type text}, {"绍兴市", type text}, {"白山市", type text}, {"葫芦岛市", type text}, {"常州市", type text}, {"四平市", type text}, {"银川市", type text}, {"安顺市", type text}, {"广安市", type text}, {"连云港市", type text}, {"眉山市", type text}, {"马鞍山市", type text}, {"江门市", type text}, {"滨州市", type text}, {"锦州市", type text}, {"汕头市", type text}, {"和田地区", type text}, {"商洛市", type text}, {"通化市", type text}, {"西宁市", type text}, {"甘南藏族自治州", type text}, {"恩施土家族苗族自治州", type text}, {"孝感市", type text}, {"朝阳市", type text}, {"平凉市", type text}, {"辽阳市", type text}, {"阜新市", type text}, {"铁岭市", type text}, {"秦皇岛市", type text}, {"延边朝鲜族自治州", type text}, {"湘西土家族苗族自治州", type text}, {"六安市", type text}, {"龙岩市", type text}, {"玉林市", type text}, {"定西市", type text}, {"泸州市", type text}, {"抚顺市", type text}, {"黔西南布依族苗族自治州", type text}, {"鞍山市", type text}, {"宣城市", type text}, {"巴彦淖尔市", type text}, {"蚌埠市", type text}, {"崇左市", type text}, {"淮南市", type text}, {"嘉兴市", type text}, {"天水市", type text}, {"黄山市", type text}, {"酒泉市", type text}, {"达州市", type text}, {"无锡市", type text}, {"梧州市", type text}, {"广元市", type text}, {"临夏回族自治州", type text}, {"文山壮族苗族自治州", type text}, {"淮安市", type text}, {"毕节市", type text}, {"拉萨市", type text}, {"清远市", type text}, {"兰州市", type text}, {"肇庆市", type text}, {"雅安市", type text}, {"庆阳市", type text}, {"梅州市", type text}, {"临沧市", type text}, {"滁州市", type text}, {"聊城市", type text}, {"阿克苏地区", type text}, {"巴音郭楞蒙古自治州", type text}, {"双鸭山市", type text}, {"淄博市", type text}, {"乌鲁木齐市", type text}, {"通辽市", type text}, {"鹤岗市", type text}, {"十堰市", type text}, {"芜湖市", type text}, {"荆州市", type text}, {"阜阳市", type text}, {"南通市", type text}, {"鸡西市", type text}, {"台州市", type text}, {"盐城市", type text}, {"曲靖市", type text}, {"绵阳市", type text}, {"吉林市", type text}, {"南充市", type text}, {"苏州市", type text}, {"陇南市", type text}, {"合肥市", type text}, {"大庆市", type text}, {"丽水市", type text}, {"宁德市", type text}, {"南昌市", type text}, {"玉溪市", type text}, {"呼和浩特市", type text}, {"金华市", type text}, {"商丘市", type text}, {"包头市", type text}, {"常德市", type text}, {"株洲市", type text}, {"长沙市", type text}, {"岳阳市", type text}, {"襄阳市", type text}, {"楚雄彝族自治州", type text}, {"安阳市", type text}, {"湛江市", type text}, {"鄂尔多斯市", type text}, {"菏泽市", type text}, {"伊犁哈萨克自治州", type text}, {"长春市", type text}, {"那曲地区", type text}, {"大连市", type text}, {"牡丹江市", type text}, {"安康市", type text}, {"铜仁市", type text}, {"普洱市", type text}, {"绥化市", type text}, {"贵阳市", type text}, {"佳木斯市", type text}, {"徐州市", type text}, {"昌都市", type text}, {"廊坊市", type text}, {"宜宾市", type text}, {"太原市", type text}, {"柳州市", type text}, {"青岛市", type text}, {"济南市", type text}, {"南平市", type text}, {"宜春市", type text}, {"周口市", type text}, {"韶关市", type text}, {"信阳市", type text}, {"焦作市", type text}, {"开封市", type text}, {"平顶山市", type text}, {"驻马店市", type text}, {"安庆市", type text}, {"黄冈市", type text}, {"德州市", type text}, {"永州市", type text}, {"郴州市", type text}, {"昭通市", type text}, {"乐山市", type text}, {"大同市", type text}, {"衡水市", type text}, {"温州市", type text}, {"晋中市", type text}, {"宁波市", type text}, {"大理白族自治州", type text}, {"广州市", type text}, {"承德市", type text}, {"河池市", type text}, {"喀什地区", type text}, {"汉中市", type text}, {"漳州市", type text}, {"南京市", type text}, {"抚州市", type text}, {"渭南市", type text}, {"黔南布依族苗族自治州", type text}, {"锡林郭勒盟", type text}, {"乌兰察布市", type text}, {"济宁市", type text}, {"邵阳市", type text}, {"怀化市", type text}, {"宝鸡市", type text}, {"榆林市", type text}, {"山南市", type text}, {"衡阳市", type text}, {"阿坝藏族羌族自治州", type text}, {"上饶市", type text}, {"南宁市", type text}, {"三明市", type text}, {"泉州市", type text}, {"百色市", type text}, {"烟台市", type text}, {"新乡市", type text}, {"红河哈尼族彝族自治州", type text}, {"赤峰市", type text}, {"潍坊市", type text}, {"临沂市", type text}, {"郑州市", type text}, {"吉安市", type text}, {"九江市", type text}, {"南阳市", type text}, {"宜昌市", type text}, {"武汉市", type text}, {"福州市", type text}, {"运城市", type text}, {"长治市", type text}, {"吕梁市", type text}, {"杭州市", type text}, {"沈阳市", type text}, {"西安市", type text}, {"县(重庆)", type text}, {"延安市", type text}, {"遵义市", type text}, {"呼伦贝尔市", type text}, {"唐山市", type text}, {"省直辖县级行政区划(海南)", type text}, {"昆明市", type text}, {"忻州市", type text}, {"咸阳市", type text}, {"市辖区(上海)", type text}, {"市辖区(北京)", type text}, {"市辖区(天津)", type text}, {"洛阳市", type text}, {"黔东南苗族侗族自治州", type text}, {"凉山彝族自治州", type text}, {"沧州市", type text}, {"齐齐哈尔市", type text}, {"张家口市", type text}, {"伊春市", type text}, {"桂林市", type text}, {"日喀则市", type text}, {"临汾市", type text}, {"甘孜藏族自治州", type text}, {"赣州市", type text}, {"哈尔滨市", type text}, {"邯郸市", type text}, {"邢台市", type text}, {"成都市", type text}, {"石家庄市", type text}, {"市辖区(重庆)", type text}, {"保定市", type text}})
in
更改的类型2
一般在操作Power Query更多的是通过图形界面操作的。而且我M学的其实不好，自己用还行，做教程就不行了。演示文件中有操作步骤，有兴趣的可以看看步骤就可以了，但是需要对M有一定的了解才能看得懂。
方法四总结：
方法四作为在Power Query里面实现的功能，可以说基本上是不受数据量限制的，一般人可能并不容易理解，但是如果你稍微有一些PQ的使用基础，这部分变动还是比较容易学习的。只是想通过这个方法告诉大家，PQ是非常强大的，远非我们表面上看到的那些，有感兴趣的也可也看看施老师的网站，更加深入的学习和理解。
网友评论