如何将Excel中一列数据的偶数列放到奇数列后面
作者:
Hasan_hs | 来源:发表于
2023-11-22 15:35 被阅读0次
![](https://img.haomeiwen.com/i5077260/5f2e6316bed41988.png)
image.png
- Excel 中有一列数据。希望将图1合并成图2的样子
![](https://img.haomeiwen.com/i5077260/d6c3015a65583b7a.png)
image.png
![](https://img.haomeiwen.com/i5077260/4d6e77c1aef18be8.png)
image.png
- 在B1中,输入 =INDIRECT("A"&(ROW()*2)-1)
![](https://img.haomeiwen.com/i5077260/e8de625811428b9d.png)
image.png
- 回车
![](https://img.haomeiwen.com/i5077260/a3d48eab757345cc.png)
image.png
- 将鼠标移到B1单元格右下角,当鼠标指示针变成实心加号时,按住鼠标左键下拉
![](https://img.haomeiwen.com/i5077260/4720746c54168c61.png)
image.png
- 在B1中,输入 =INDIRECT("A"&(ROW()*2))
![](https://img.haomeiwen.com/i5077260/3035f0ea5c185ff9.png)
image.png
-
回车
image.png
- 将鼠标移到C1单元格右下角,当鼠标指示针变成实心加号时,按住鼠标左键下拉
![](https://img.haomeiwen.com/i5077260/97e266ce16d6eff2.png)
image.png
- 在D1中,输入 =B1&C1
![](https://img.haomeiwen.com/i5077260/7443ef7d24067aa1.png)
image.png
- 回车
![](https://img.haomeiwen.com/i5077260/95a892e9764ee85e.png)
image.png
- 10
将鼠标移到D1单元格右下角,当鼠标指示针变成实心加号时,按住鼠标左键**下拉**
![](https://img.haomeiwen.com/i5077260/ea318b67c04b66c1.png)
image.png
本文标题:如何将Excel中一列数据的偶数列放到奇数列后面
本文链接:https://www.haomeiwen.com/subject/ccfwwdtx.html
网友评论