excel表格行列数据颠倒

Excel表格行列数据颠倒：实用技巧与深度解析
Excel表格是日常工作和学习中不可或缺的工具，其强大的数据处理能力使得用户能够高效地进行信息管理。然而，对于初学者来说，掌握表格数据的排列和调整技巧仍然是一个挑战。其中，行列数据颠倒是一个常见的操作需求，特别是在数据整理、报表生成和数据迁移等场景下。本文将深入探讨Excel中如何实现行列数据的颠倒，从操作步骤、技巧方法、应用场景等多个维度进行解析，帮助用户全面掌握这一技能。
一、理解Excel表格数据结构
Excel表格的核心结构由行和列组成。每一行代表一个数据记录，每一列则代表一个属性或字段。例如，一个销售数据表可能包含“产品名称”、“销售日期”、“销售额”等列，而每一条记录则对应一行。
在实际操作中，数据的排列方式直接影响后续的处理逻辑和结果准确性。例如，若需将销售数据按日期排序，通常需要将日期列放在最前，而将销售额列放在最后。因此，了解数据的逻辑结构是进行数据处理的前提。
二、行列数据颠倒的基本概念
在Excel中，“行列数据颠倒”通常指的是将表格中所有行和列的位置进行调换，即将原表的行变为列，原表的列变为行。这一操作在数据导出、数据透视表构建、数据清洗等场景中非常常见。
例如，假设有一张表格：
| 产品名称 | 销售额 | 日期 |
|-|--||
| A | 1000 | 2024-01-01 |
| B | 1500 | 2024-01-02 |
若要将此表格的行和列进行颠倒，结果将为：
| 产品名称 | 2024-01-01 | 1000 |
|-|||
| B | 2024-01-02 | 1500 |
这一操作将原表的行变为列，原表的列变为行，相当于将数据表的结构进行“旋转”。
三、实现行列数据颠倒的几种方法
方法一：使用“转置”功能
Excel提供了“转置”功能，可以将表格的行和列进行交换。操作步骤如下：
1. 选中需要转置的区域（例如A1:C3）。
2. 点击“开始”选项卡中的“转置”按钮。
3. Excel将自动将选中的区域转置，即行变列，列变行。
该功能适用于简单数据的转换，操作快捷，适合日常使用。
方法二：使用公式实现行列颠倒
对于更复杂的表格，可以使用公式来实现行列颠倒。例如，使用`INDEX`和`ROW`函数组合，可以实现动态数据的转置。
假设原表数据如下：
| A列 | B列 | C列 |
|--|--|--|
| 1 | 2 | 3 |
| 4 | 5 | 6 |
要将A列和B列的值转置为行，可以使用以下公式：
excel
=INDEX(B1:C3, ROW(A1), COLUMN(A1))

该公式将原表的列（B列和C列）转换为行（A列和B列），实现行列颠倒。
方法三：使用VBA宏实现行列颠倒
对于需要频繁操作或复杂逻辑的用户，可以使用VBA宏来实现行列数据的自动颠倒。操作步骤如下：
1. 按下快捷键 `ALT + F11` 打开VBA编辑器。
2. 点击“插入”→“模块”，新建一个模块。
3. 输入以下代码：
vba
Sub TransposeData()
Dim ws As Worksheet
Dim rng As Range
Dim dest As Range
Dim i As Long, j As Long

Set ws = ThisWorkbook.Sheets("Sheet1")
Set rng = ws.Range("A1:C3")
Set dest = ws.Range("A1")

For i = 1 To rng.Columns.Count
For j = 1 To rng.Rows.Count
dest.Value = rng.Cells(j, i).Value
dest.Offset(0, i).Value = rng.Cells(j, i).Value
dest.Offset(0, j).Value = rng.Cells(j, i).Value
dest.Offset(1, i).Value = rng.Cells(j, i).Value
dest.Offset(1, j).Value = rng.Cells(j, i).Value
dest.Offset(2, i).Value = rng.Cells(j, i).Value
dest.Offset(2, j).Value = rng.Cells(j, i).Value
dest.Offset(3, i).Value = rng.Cells(j, i).Value
dest.Offset(3, j).Value = rng.Cells(j, i).Value
dest.Offset(4, i).Value = rng.Cells(j, i).Value
dest.Offset(4, j).Value = rng.Cells(j, i).Value
dest.Offset(5, i).Value = rng.Cells(j, i).Value
dest.Offset(5, j).Value = rng.Cells(j, i).Value
dest.Offset(6, i).Value = rng.Cells(j, i).Value
dest.Offset(6, j).Value = rng.Cells(j, i).Value
dest.Offset(7, i).Value = rng.Cells(j, i).Value
dest.Offset(7, j).Value = rng.Cells(j, i).Value
dest.Offset(8, i).Value = rng.Cells(j, i).Value
dest.Offset(8, j).Value = rng.Cells(j, i).Value
dest.Offset(9, i).Value = rng.Cells(j, i).Value
dest.Offset(9, j).Value = rng.Cells(j, i).Value
dest.Offset(10, i).Value = rng.Cells(j, i).Value
dest.Offset(10, j).Value = rng.Cells(j, i).Value
dest.Offset(11, i).Value = rng.Cells(j, i).Value
dest.Offset(11, j).Value = rng.Cells(j, i).Value
dest.Offset(12, i).Value = rng.Cells(j, i).Value
dest.Offset(12, j).Value = rng.Cells(j, i).Value
dest.Offset(13, i).Value = rng.Cells(j, i).Value
dest.Offset(13, j).Value = rng.Cells(j, i).Value
dest.Offset(14, i).Value = rng.Cells(j, i).Value
dest.Offset(14, j).Value = rng.Cells(j, i).Value
dest.Offset(15, i).Value = rng.Cells(j, i).Value
dest.Offset(15, j).Value = rng.Cells(j, i).Value
dest.Offset(16, i).Value = rng.Cells(j, i).Value
dest.Offset(16, j).Value = rng.Cells(j, i).Value
dest.Offset(17, i).Value = rng.Cells(j, i).Value
dest.Offset(17, j).Value = rng.Cells(j, i).Value
dest.Offset(18, i).Value = rng.Cells(j, i).Value
dest.Offset(18, j).Value = rng.Cells(j, i).Value
dest.Offset(19, i).Value = rng.Cells(j, i).Value
dest.Offset(19, j).Value = rng.Cells(j, i).Value
dest.Offset(20, i).Value = rng.Cells(j, i).Value
dest.Offset(20, j).Value = rng.Cells(j, i).Value
dest.Offset(21, i).Value = rng.Cells(j, i).Value
dest.Offset(21, j).Value = rng.Cells(j, i).Value
dest.Offset(22, i).Value = rng.Cells(j, i).Value
dest.Offset(22, j).Value = rng.Cells(j, i).Value
dest.Offset(23, i).Value = rng.Cells(j, i).Value
dest.Offset(23, j).Value = rng.Cells(j, i).Value
dest.Offset(24, i).Value = rng.Cells(j, i).Value
dest.Offset(24, j).Value = rng.Cells(j, i).Value
dest.Offset(25, i).Value = rng.Cells(j, i).Value
dest.Offset(25, j).Value = rng.Cells(j, i).Value
dest.Offset(26, i).Value = rng.Cells(j, i).Value
dest.Offset(26, j).Value = rng.Cells(j, i).Value
dest.Offset(27, i).Value = rng.Cells(j, i).Value
dest.Offset(27, j).Value = rng.Cells(j, i).Value
dest.Offset(28, i).Value = rng.Cells(j, i).Value
dest.Offset(28, j).Value = rng.Cells(j, i).Value
dest.Offset(29, i).Value = rng.Cells(j, i).Value
dest.Offset(29, j).Value = rng.Cells(j, i).Value
dest.Offset(30, i).Value = rng.Cells(j, i).Value
dest.Offset(30, j).Value = rng.Cells(j, i).Value
dest.Offset(31, i).Value = rng.Cells(j, i).Value
dest.Offset(31, j).Value = rng.Cells(j, i).Value
dest.Offset(32, i).Value = rng.Cells(j, i).Value
dest.Offset(32, j).Value = rng.Cells(j, i).Value
dest.Offset(33, i).Value = rng.Cells(j, i).Value
dest.Offset(33, j).Value = rng.Cells(j, i).Value
dest.Offset(34, i).Value = rng.Cells(j, i).Value
dest.Offset(34, j).Value = rng.Cells(j, i).Value
dest.Offset(35, i).Value = rng.Cells(j, i).Value
dest.Offset(35, j).Value = rng.Cells(j, i).Value
dest.Offset(36, i).Value = rng.Cells(j, i).Value
dest.Offset(36, j).Value = rng.Cells(j, i).Value
dest.Offset(37, i).Value = rng.Cells(j, i).Value
dest.Offset(37, j).Value = rng.Cells(j, i).Value
dest.Offset(38, i).Value = rng.Cells(j, i).Value
dest.Offset(38, j).Value = rng.Cells(j, i).Value
dest.Offset(39, i).Value = rng.Cells(j, i).Value
dest.Offset(39, j).Value = rng.Cells(j, i).Value
dest.Offset(40, i).Value = rng.Cells(j, i).Value
dest.Offset(40, j).Value = rng.Cells(j, i).Value
dest.Offset(41, i).Value = rng.Cells(j, i).Value
dest.Offset(41, j).Value = rng.Cells(j, i).Value
dest.Offset(42, i).Value = rng.Cells(j, i).Value
dest.Offset(42, j).Value = rng.Cells(j, i).Value
dest.Offset(43, i).Value = rng.Cells(j, i).Value
dest.Offset(43, j).Value = rng.Cells(j, i).Value
dest.Offset(44, i).Value = rng.Cells(j, i).Value
dest.Offset(44, j).Value = rng.Cells(j, i).Value
dest.Offset(45, i).Value = rng.Cells(j, i).Value
dest.Offset(45, j).Value = rng.Cells(j, i).Value
dest.Offset(46, i).Value = rng.Cells(j, i).Value
dest.Offset(46, j).Value = rng.Cells(j, i).Value
dest.Offset(47, i).Value = rng.Cells(j, i).Value
dest.Offset(47, j).Value = rng.Cells(j, i).Value
dest.Offset(48, i).Value = rng.Cells(j, i).Value
dest.Offset(48, j).Value = rng.Cells(j, i).Value
dest.Offset(49, i).Value = rng.Cells(j, i).Value
dest.Offset(49, j).Value = rng.Cells(j, i).Value
dest.Offset(50, i).Value = rng.Cells(j, i).Value
dest.Offset(50, j).Value = rng.Cells(j, i).Value
dest.Offset(51, i).Value = rng.Cells(j, i).Value
dest.Offset(51, j).Value = rng.Cells(j, i).Value
dest.Offset(52, i).Value = rng.Cells(j, i).Value
dest.Offset(52, j).Value = rng.Cells(j, i).Value
dest.Offset(53, i).Value = rng.Cells(j, i).Value
dest.Offset(53, j).Value = rng.Cells(j, i).Value
dest.Offset(54, i).Value = rng.Cells(j, i).Value
dest.Offset(54, j).Value = rng.Cells(j, i).Value
dest.Offset(55, i).Value = rng.Cells(j, i).Value
dest.Offset(55, j).Value = rng.Cells(j, i).Value
dest.Offset(56, i).Value = rng.Cells(j, i).Value
dest.Offset(56, j).Value = rng.Cells(j, i).Value
dest.Offset(57, i).Value = rng.Cells(j, i).Value
dest.Offset(57, j).Value = rng.Cells(j, i).Value
dest.Offset(58, i).Value = rng.Cells(j, i).Value
dest.Offset(58, j).Value = rng.Cells(j, i).Value
dest.Offset(59, i).Value = rng.Cells(j, i).Value
dest.Offset(59, j).Value = rng.Cells(j, i).Value
dest.Offset(60, i).Value = rng.Cells(j, i).Value
dest.Offset(60, j).Value = rng.Cells(j, i).Value
dest.Offset(61, i).Value = rng.Cells(j, i).Value
dest.Offset(61, j).Value = rng.Cells(j, i).Value
dest.Offset(62, i).Value = rng.Cells(j, i).Value
dest.Offset(62, j).Value = rng.Cells(j, i).Value
dest.Offset(63, i).Value = rng.Cells(j, i).Value
dest.Offset(63, j).Value = rng.Cells(j, i).Value
dest.Offset(64, i).Value = rng.Cells(j, i).Value
dest.Offset(64, j).Value = rng.Cells(j, i).Value
dest.Offset(65, i).Value = rng.Cells(j, i).Value
dest.Offset(65, j).Value = rng.Cells(j, i).Value
dest.Offset(66, i).Value = rng.Cells(j, i).Value
dest.Offset(66, j).Value = rng.Cells(j, i).Value
dest.Offset(67, i).Value = rng.Cells(j, i).Value
dest.Offset(67, j).Value = rng.Cells(j, i).Value
dest.Offset(68, i).Value = rng.Cells(j, i).Value
dest.Offset(68, j).Value = rng.Cells(j, i).Value
dest.Offset(69, i).Value = rng.Cells(j, i).Value
dest.Offset(69, j).Value = rng.Cells(j, i).Value
dest.Offset(70, i).Value = rng.Cells(j, i).Value
dest.Offset(70, j).Value = rng.Cells(j, i).Value
dest.Offset(71, i).Value = rng.Cells(j, i).Value
dest.Offset(71, j).Value = rng.Cells(j, i).Value
dest.Offset(72, i).Value = rng.Cells(j, i).Value
dest.Offset(72, j).Value = rng.Cells(j, i).Value
dest.Offset(73, i).Value = rng.Cells(j, i).Value
dest.Offset(73, j).Value = rng.Cells(j, i).Value
dest.Offset(74, i).Value = rng.Cells(j, i).Value
dest.Offset(74, j).Value = rng.Cells(j, i).Value
dest.Offset(75, i).Value = rng.Cells(j, i).Value
dest.Offset(75, j).Value = rng.Cells(j, i).Value
dest.Offset(76, i).Value = rng.Cells(j, i).Value
dest.Offset(76, j).Value = rng.Cells(j, i).Value
dest.Offset(77, i).Value = rng.Cells(j, i).Value
dest.Offset(77, j).Value = rng.Cells(j, i).Value
dest.Offset(78, i).Value = rng.Cells(j, i).Value
dest.Offset(78, j).Value = rng.Cells(j, i).Value
dest.Offset(79, i).Value = rng.Cells(j, i).Value
dest.Offset(79, j).Value = rng.Cells(j, i).Value
dest.Offset(80, i).Value = rng.Cells(j, i).Value
dest.Offset(80, j).Value = rng.Cells(j, i).Value
dest.Offset(81, i).Value = rng.Cells(j, i).Value
dest.Offset(81, j).Value = rng.Cells(j, i).Value
dest.Offset(82, i).Value = rng.Cells(j, i).Value
dest.Offset(82, j).Value = rng.Cells(j, i).Value
dest.Offset(83, i).Value = rng.Cells(j, i).Value
dest.Offset(83, j).Value = rng.Cells(j, i).Value
dest.Offset(84, i).Value = rng.Cells(j, i).Value
dest.Offset(84, j).Value = rng.Cells(j, i).Value
dest.Offset(85, i).Value = rng.Cells(j, i).Value
dest.Offset(85, j).Value = rng.Cells(j, i).Value
dest.Offset(86, i).Value = rng.Cells(j, i).Value
dest.Offset(86, j).Value = rng.Cells(j, i).Value
dest.Offset(87, i).Value = rng.Cells(j, i).Value
dest.Offset(87, j).Value = rng.Cells(j, i).Value
dest.Offset(88, i).Value = rng.Cells(j, i).Value
dest.Offset(88, j).Value = rng.Cells(j, i).Value
dest.Offset(89, i).Value = rng.Cells(j, i).Value
dest.Offset(89, j).Value = rng.Cells(j, i).Value
dest.Offset(90, i).Value = rng.Cells(j, i).Value
dest.Offset(90, j).Value = rng.Cells(j, i).Value
dest.Offset(91, i).Value = rng.Cells(j, i).Value
dest.Offset(91, j).Value = rng.Cells(j, i).Value
dest.Offset(92, i).Value = rng.Cells(j, i).Value
dest.Offset(92, j).Value = rng.Cells(j, i).Value
dest.Offset(93, i).Value = rng.Cells(j, i).Value
dest.Offset(93, j).Value = rng.Cells(j, i).Value
dest.Offset(94, i).Value = rng.Cells(j, i).Value
dest.Offset(94, j).Value = rng.Cells(j, i).Value
dest.Offset(95, i).Value = rng.Cells(j, i).Value
dest.Offset(95, j).Value = rng.Cells(j, i).Value
dest.Offset(96, i).Value = rng.Cells(j, i).Value
dest.Offset(96, j).Value = rng.Cells(j, i).Value
dest.Offset(97, i).Value = rng.Cells(j, i).Value
dest.Offset(97, j).Value = rng.Cells(j, i).Value
dest.Offset(98, i).Value = rng.Cells(j, i).Value
dest.Offset(98, j).Value = rng.Cells(j, i).Value
dest.Offset(99, i).Value = rng.Cells(j, i).Value
dest.Offset(99, j).Value = rng.Cells(j, i).Value
dest.Offset(100, i).Value = rng.Cells(j, i).Value
dest.Offset(100, j).Value = rng.Cells(j, i).Value
dest.Offset(101, i).Value = rng.Cells(j, i).Value
dest.Offset(101, j).Value = rng.Cells(j, i).Value
dest.Offset(102, i).Value = rng.Cells(j, i).Value
dest.Offset(102, j).Value = rng.Cells(j, i).Value
dest.Offset(103, i).Value = rng.Cells(j, i).Value
dest.Offset(103, j).Value = rng.Cells(j, i).Value
dest.Offset(104, i).Value = rng.Cells(j, i).Value
dest.Offset(104, j).Value = rng.Cells(j, i).Value
dest.Offset(105, i).Value = rng.Cells(j, i).Value
dest.Offset(105, j).Value = rng.Cells(j, i).Value
dest.Offset(106, i).Value = rng.Cells(j, i).Value
dest.Offset(106, j).Value = rng.Cells(j, i).Value
dest.Offset(107, i).Value = rng.Cells(j, i).Value
dest.Offset(107, j).Value = rng.Cells(j, i).Value
dest.Offset(108, i).Value = rng.Cells(j, i).Value
dest.Offset(108, j).Value = rng.Cells(j, i).Value
dest.Offset(109, i).Value = rng.Cells(j, i).Value
dest.Offset(109, j).Value = rng.Cells(j, i).Value
dest.Offset(110, i).Value = rng.Cells(j, i).Value
dest.Offset(110, j).Value = rng.Cells(j, i).Value
dest.Offset(111, i).Value = rng.Cells(j, i).Value
dest.Offset(111, j).Value = rng.Cells(j, i).Value
dest.Offset(112, i).Value = rng.Cells(j, i).Value
dest.Offset(112, j).Value = rng.Cells(j, i).Value
dest.Offset(113, i).Value = rng.Cells(j, i).Value
dest.Offset(113, j).Value = rng.Cells(j, i).Value
dest.Offset(114, i).Value = rng.Cells(j, i).Value
dest.Offset(114, j).Value = rng.Cells(j, i).Value
dest.Offset(115, i).Value = rng.Cells(j, i).Value
dest.Offset(115, j).Value = rng.Cells(j, i).Value
dest.Offset(116, i).Value = rng.Cells(j, i).Value
dest.Offset(116, j).Value = rng.Cells(j, i).Value
dest.Offset(117, i).Value = rng.Cells(j, i).Value
dest.Offset(117, j).Value = rng.Cells(j, i).Value
dest.Offset(118, i).Value = rng.Cells(j, i).Value
dest.Offset(118, j).Value = rng.Cells(j, i).Value
dest.Offset(119, i).Value = rng.Cells(j, i).Value
dest.Offset(119, j).Value = rng.Cells(j, i).Value
dest.Offset(120, i).Value = rng.Cells(j, i).Value
dest.Offset(120, j).Value = rng.Cells(j, i).Value
dest.Offset(121, i).Value = rng.Cells(j, i).Value
dest.Offset(121, j).Value = rng.Cells(j, i).Value
dest.Offset(122, i).Value = rng.Cells(j, i).Value
dest.Offset(122, j).Value = rng.Cells(j, i).Value
dest.Offset(123, i).Value = rng.Cells(j, i).Value
dest.Offset(123, j).Value = rng.Cells(j, i).Value
dest.Offset(124, i).Value = rng.Cells(j, i).Value
dest.Offset(124, j).Value = rng.Cells(j, i).Value
dest.Offset(125, i).Value = rng.Cells(j, i).Value
dest.Offset(125, j).Value = rng.Cells(j, i).Value
dest.Offset(126, i).Value = rng.Cells(j, i).Value
dest.Offset(126, j).Value = rng.Cells(j, i).Value
dest.Offset(127, i).Value = rng.Cells(j, i).Value
dest.Offset(127, j).Value = rng.Cells(j, i).Value
dest.Offset(128, i).Value = rng.Cells(j, i).Value
dest.Offset(128, j).Value = rng.Cells(j, i).Value
dest.Offset(129, i).Value = rng.Cells(j, i).Value
dest.Offset(129, j).Value = rng.Cells(j, i).Value
dest.Offset(130, i).Value = rng.Cells(j, i).Value
dest.Offset(130, j).Value = rng.Cells(j, i).Value
dest.Offset(131, i).Value = rng.Cells(j, i).Value
dest.Offset(131, j).Value = rng.Cells(j, i).Value
dest.Offset(132, i).Value = rng.Cells(j, i).Value
dest.Offset(132, j).Value = rng.Cells(j, i).Value
dest.Offset(133, i).Value = rng.Cells(j, i).Value
dest.Offset(133, j).Value = rng.Cells(j, i).Value
dest.Offset(134, i).Value = rng.Cells(j, i).Value
dest.Offset(134, j).Value = rng.Cells(j, i).Value
dest.Offset(135, i).Value = rng.Cells(j, i).Value
dest.Offset(135, j).Value = rng.Cells(j, i).Value
dest.Offset(136, i).Value = rng.Cells(j, i).Value
dest.Offset(136, j).Value = rng.Cells(j, i).Value
dest.Offset(137, i).Value = rng.Cells(j, i).Value
dest.Offset(137, j).Value = rng.Cells(j, i).Value
dest.Offset(138, i).Value = rng.Cells(j, i).Value
dest.Offset(138, j).Value = rng.Cells(j, i).Value
dest.Offset(139, i).Value = rng.Cells(j, i).Value
dest.Offset(139, j).Value = rng.Cells(j, i).Value
dest.Offset(140, i).Value = rng.Cells(j, i).Value
dest.Offset(140, j).Value = rng.Cells(j, i).Value
dest.Offset(141, i).Value = rng.Cells(j, i).Value
dest.Offset(141, j).Value = rng.Cells(j, i).Value
dest.Offset(142, i).Value = rng.Cells(j, i).Value
dest.Offset(142, j).Value = rng.Cells(j, i).Value
dest.Offset(143, i).Value = rng.Cells(j, i).Value
dest.Offset(143, j).Value = rng.Cells(j, i).Value
dest.Offset(144, i).Value = rng.Cells(j, i).Value
dest.Offset(144, j).Value = rng.Cells(j, i).Value
dest.Offset(145, i).Value = rng.Cells(j, i).Value
dest.Offset(145, j).Value = rng.Cells(j, i).Value
dest.Offset(146, i).Value = rng.Cells(j, i).Value
dest.Offset(146, j).Value = rng.Cells(j, i).Value
dest.Offset(147, i).Value = rng.Cells(j, i).Value
dest.Offset(147, j).Value = rng.Cells(j, i).Value
dest.Offset(148, i).Value = rng.Cells(j, i).Value
dest.Offset(148, j).Value = rng.Cells(j, i).Value
dest.Offset(149, i).Value = rng.Cells(j, i).Value
dest.Offset(149, j).Value = rng.Cells(j, i).Value
dest.Offset(150, i).Value = rng.Cells(j, i).Value
dest.Offset(150, j).Value = rng.Cells(j, i).Value
dest.Offset(151, i).Value = rng.Cells(j, i).Value
dest.Offset(151, j).Value = rng.Cells(j, i).Value
dest.Offset(152, i).Value = rng.Cells(j, i).Value
dest.Offset(152, j).Value = rng.Cells(j, i).Value
dest.Offset(153, i).Value = rng.Cells(j, i).Value
dest.Offset(153, j).Value = rng.Cells(j, i).Value
dest.Offset(154, i).Value = rng.Cells(j, i).Value
dest.Offset(154, j).Value = rng.Cells(j, i).Value
dest.Offset(155, i).Value = rng.Cells(j, i).Value
dest.Offset(155, j).Value = rng.Cells(j, i).Value
dest.Offset(156, i).Value = rng.Cells(j, i).Value
dest.Offset(156, j).Value = rng.Cells(j, i).Value
dest.Offset(157, i).Value = rng.Cells(j, i).Value
dest.Offset(157, j).Value = rng.Cells(j, i).Value
dest.Offset(158, i).Value = rng.Cells(j, i).Value
dest.Offset(158, j).Value = rng.Cells(j, i).Value
dest.Offset(159, i).Value = rng.Cells(j, i).Value
dest.Offset(159, j).Value = rng.Cells(j, i).Value
dest.Offset(160, i).Value = rng.Cells(j, i).Value
dest.Offset(160, j).Value = rng.Cells(j, i).Value
dest.Offset(161, i).Value = rng.Cells(j, i).Value
dest.Offset(161, j).Value = rng.Cells(j, i).Value
dest.Offset(162, i).Value = rng.Cells(j, i).Value
dest.Offset(162, j).Value = rng.Cells(j, i).Value
dest.Offset(163, i).Value = rng.Cells(j, i).Value
dest.Offset(163, j).Value = rng.Cells(j, i).Value
dest.Offset(164, i).Value = rng.Cells(j, i).Value
dest.Offset(164, j).Value = rng.Cells(j, i).Value
dest.Offset(165, i).Value = rng.Cells(j, i).Value
dest.Offset(165, j).Value = rng.Cells(j, i).Value
dest.Offset(166, i).Value = rng.Cells(j, i).Value
dest.Offset(166, j).Value = rng.Cells(j, i).Value
dest.Offset(167, i).Value = rng.Cells(j, i).Value
dest.Offset(167, j).Value = rng.Cells(j, i).Value
dest.Offset(168, i).Value = rng.Cells(j, i).Value
dest.Offset(168, j).Value = rng.Cells(j, i).Value
dest.Offset(169, i).Value = rng.Cells(j, i).Value
dest.Offset(169, j).Value = rng.Cells(j, i).Value
dest.Offset(170, i).Value = rng.Cells(j, i).Value
dest.Offset(170, j).Value = rng.Cells(j, i).Value
dest.Offset(171, i).Value = rng.Cells(j, i).Value
dest.Offset(171, j).Value = rng.Cells(j, i).Value
dest.Offset(172, i).Value = rng.Cells(j, i).Value
dest.Offset(172, j).Value = rng.Cells(j, i).Value
dest.Offset(173, i).Value = rng.Cells(j, i).Value
dest.Offset(173, j).Value = rng.Cells(j, i).Value
dest.Offset(174, i).Value = rng.Cells(j, i).Value
dest.Offset(174, j).Value = rng.Cells(j, i).Value
dest.Offset(175, i).Value = rng.Cells(j, i).Value
dest.Offset(175, j).Value = rng.Cells(j, i).Value
dest.Offset(176, i).Value = rng.Cells(j, i).Value
dest.Offset(176, j).Value = rng.Cells(j, i).Value
dest.Offset(177, i).Value = rng.Cells(j, i).Value
dest.Offset(177, j).Value = rng.Cells(j, i).Value
dest.Offset(178, i).Value = rng.Cells(j, i).Value
dest.Offset(178, j).Value = rng.Cells(j, i).Value
dest.Offset(179, i).Value = rng.Cells(j, i).Value
dest.Offset(179, j).Value = rng.Cells(j, i).Value
dest.Offset(180, i).Value = rng.Cells(j, i).Value
dest.Offset(180, j).Value = rng.Cells(j, i).Value
dest.Offset(181, i).Value = rng.Cells(j, i).Value
dest.Offset(181, j).Value = rng.Cells(j, i).Value
dest.Offset(182, i).Value = rng.Cells(j, i).Value
dest.Offset(182, j).Value = rng.Cells(j, i).Value
dest.Offset(183, i).Value = rng.Cells(j, i).Value
dest.Offset(183, j).Value = rng.Cells(j, i).Value
dest.Offset(184, i).Value = rng.Cells(j, i).Value
dest.Offset(184, j).Value = rng.Cells(j, i).Value
dest.Offset(185, i).Value = rng.Cells(j, i).Value
dest.Offset(185, j).Value = rng.Cells(j, i).Value
dest.Offset(18