当前时间： 2026-05-25 08:46:04
分类：办公文件
评论(0)
Excel行列互换/行列转置的2种常用方法在Excel中大多数人的习惯是数据按列存储的，但也有一些数据是按行存储的，见下图就能明白我说的意思：如果你拿到的数据表并不是按你需求进行存储的，这时候就需要用到行列转置（也称行列互换）了。方法一：复制▶︎选择性粘贴
- 在目标位置右击 ▶︎ 选择性粘贴 ▶︎ 勾选“转置” ▶︎ 确定
方法二：使用transpose函数
补充说明：这种方式实现的行列转换时，目标部分的数据是会随着源数据的更新而变化的，也就是说：目标区域只是对源区域的数据的引用。如下图所示：
⚠️注意：用transpose函数互换之后，日期、时间、货币、会计专用等数据会变为数字形式，需要重新设置一次相应的单元格格式才行。行列互换是一种非常简单的操作，在电脑上实践一次就能掌握，赶快去试一下吧！如果你连数据都不想输入的话，我这里提供了一个表格对应的CSV数据给你，复制并粘贴到Excel即可。- End -
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-27 20:52:50 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/664900.html
- 运行时间 : 0.090926s [ 吞吐率：11.00req/s ] 内存消耗：4,823.86kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=8551618b8c9940ec730159795714716e
- CONNECT:[ UseTime:0.000639s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000826s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000346s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000328s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000577s ]
- SELECT * FROM `set` [ RunTime:0.000273s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000564s ]
- SELECT * FROM `article` WHERE `id` = 664900 LIMIT 1 [ RunTime:0.000474s ]
- UPDATE `article` SET `lasttime` = 1779886370 WHERE `id` = 664900 [ RunTime:0.001144s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000271s ]
- SELECT * FROM `article` WHERE `id` < 664900 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
- SELECT * FROM `article` WHERE `id` > 664900 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000466s ]
- SELECT * FROM `article` WHERE `id` < 664900 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000837s ]
- SELECT * FROM `article` WHERE `id` < 664900 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000850s ]
- SELECT * FROM `article` WHERE `id` < 664900 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000898s ]
0.092653s
夜雨聆风
