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