如何访问raow值,然后在连续的行中重复它我从excel数据透视表导入数据。我需要读取一个行值,然后对13个连续的行重复它。
读取值A12并在接下来的13行中重复该操作,然后读取A22并在接下来的13行中重复操作。是否有捷径可寻?
| 列A | 列B | 列C | 列D | 列E | 列F | 列G |
| VarA | 值 | 数学 | 数学 | 能源部1 | AA12 | 一种 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一种 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一种 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一种 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一种 |
| | | | | | | 乙 |
| | | | | | AA总计 | |
| | | | | DOE1总计 | | |
| | | | | DOE1-W55 | AA22 | 一种 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一种 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一种 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一种 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一种 |
| | | | | | | 乙 |
| | | | | | 总计AA22 | |
| | | | | DOE1总计 | | |