![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/82c884ad0f418c00e124e08f79df100a.jpg)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/4dfeae35853b4492063e711c8608204a.jpg)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/a757711bd07810d66ecac9d4a58982c0.jpg)
Excel二维表如何转换为一维表?
![](/static/index/images/article/time.png)
Excel中如果要将一行数据拆分成多行,如下图所示的拆分,你是如何操作的呢?成千上万行数据,复制粘贴耗费大量的时间!教你用PQ的逆透视列轻松搞定。
![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/1b018d4c2a05ed2bb021c8eb0a09588d.jpg)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/0c4264c58a0e5df21c2a3a3b0528c31b.jpg)
Word自动编号怎么取消?
![](/static/index/images/article/time.png)
Word自动编号怎么取消?Word自动编号在办公中对我们来说是个不错的功能,但是有时候不需要这种自动编号,回车就会自动输入,反而觉得是个麻烦,怎么样解决这个自动添加编号的问题呢?
![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/5b383d8ea698cbf9213cfae6350b743c.jpg)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/c252592101420cb29783c9d8710e56c2.jpg)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/1f4e20335effa7691867c95d9778585d.jpg)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/aa56100b766d29b1488a37bd66e816b8.jpg)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200819/b482e857a7f9a010dbc22b221aa156f7.jpg)
如何提取excel单元格中的内容?英文、数字或汉字!
![](/static/index/images/article/time.png)
日常工作中都会遇到一些不规范的数据,对于数据的提取是个头疼的事情,今天教大家用Power Query快速提取单元格中的英文内容。