1.导入后台数据
![](https://img.haomeiwen.com/i10844611/97b2830f41b53bfb.png)
![](https://img.haomeiwen.com/i10844611/23552bee207d5f75.png)
![](https://img.haomeiwen.com/i10844611/d7ed3bc7b6f7fe07.png)
![](https://img.haomeiwen.com/i10844611/fbe1074e2d999b22.png)
![](https://img.haomeiwen.com/i10844611/44d1759adc1b6c7b.png)
![](https://img.haomeiwen.com/i10844611/f6a1321b4da6df9c.png)
![](https://img.haomeiwen.com/i10844611/0def7b99c4f83f70.png)
2.去空白格
选中第一列所以数据
![](https://img.haomeiwen.com/i10844611/be72b53d663a895d.png)
开始--》查找
![](https://img.haomeiwen.com/i10844611/10cbcdb9d63d7546.png)
![](https://img.haomeiwen.com/i10844611/83c7817b6d44f211.png)
![](https://img.haomeiwen.com/i10844611/81abbcbf51c39513.png)
点击鼠标右键,选中删除
![](https://img.haomeiwen.com/i10844611/de2a8ca777bb6943.png)
![](https://img.haomeiwen.com/i10844611/956bdfa5197deb0b.png)
![](https://img.haomeiwen.com/i10844611/3a6e87231ffe6bbf.png)
3.清理格式
![](https://img.haomeiwen.com/i10844611/23391ccd8f1cbdd6.png)
![](https://img.haomeiwen.com/i10844611/76feeef91d6e5859.png)
4.另一种后台数据的导入和整理
![](https://img.haomeiwen.com/i10844611/137a06559b28c649.png)
把数据复制粘贴到一格中
![](https://img.haomeiwen.com/i10844611/89615eca00d838bb.png)
![](https://img.haomeiwen.com/i10844611/10df7b9f627fc4cc.png)
![](https://img.haomeiwen.com/i10844611/c4efb26734b3755b.png)
![](https://img.haomeiwen.com/i10844611/ec7a5f0ddaf78556.png)
全选,Ctrl+C
![](https://img.haomeiwen.com/i10844611/c5f1cd4a04ee4565.png)
转置:选中空白单元格,右键点击
![](https://img.haomeiwen.com/i10844611/a0b453bc3382be73.png)
![](https://img.haomeiwen.com/i10844611/f99c127d35a2dde9.png)
分列
![](https://img.haomeiwen.com/i10844611/983b637416e6397e.png)
![](https://img.haomeiwen.com/i10844611/f3fd93274e691829.png)
再进行两次分列去括号,最终成功:
![](https://img.haomeiwen.com/i10844611/ad8b15ed560d3524.png)
1.导入后台数据
2.去空白格
选中第一列所以数据
开始--》查找
点击鼠标右键,选中删除
3.清理格式
4.另一种后台数据的导入和整理
把数据复制粘贴到一格中
全选,Ctrl+C
转置:选中空白单元格,右键点击
分列
再进行两次分列去括号,最终成功:
本文标题:Excel学习笔记 ||「分列」数据整理效率翻倍
本文链接:https://www.haomeiwen.com/subject/essdfctx.html
网友评论