【Excel】Excel小技巧：如何快速把两行数据整理成一行（课程表）？

在做课程总表里面单独某个科目的总表时，在数据处理过程中，需要将两行数据整理成一行，格式如下

（将&替换成&"^l"&  其中双引号" "是用来连接字符的，^l 是excel里面在同一行的回车）

如果之前有做过，那就利用之前的表格，把处理的第一列数据复制过来（它会自动复制公式） 然后稍微修改一下，选中处理好的那列数据，进行整张表格的填充

 

处理过程：

 

 

 

 

 

通用数据格式整理：将 & 替换成  &"^l"&

=Sheet1!B4&Sheet1!B5
=Sheet1!B6&Sheet1!B7
=Sheet1!B8&Sheet1!B9
=Sheet1!B10&Sheet1!B11
=Sheet1!B12&Sheet1!B13
=Sheet1!B14&Sheet1!B15
=Sheet1!B16&Sheet1!B17
=Sheet1!B18&Sheet1!B19
=Sheet1!B20&Sheet1!B21
=Sheet1!B22&Sheet1!B23
=Sheet1!B24&Sheet1!B25
=Sheet1!B26&Sheet1!B27
=Sheet1!B28&Sheet1!B29
=Sheet1!B30&Sheet1!B31
=Sheet1!B32&Sheet1!B33
=Sheet1!B34&Sheet1!B35
=Sheet1!B36&Sheet1!B37
=Sheet1!B38&Sheet1!B39
=Sheet1!B40&Sheet1!B41
=Sheet1!B42&Sheet1!B43
=Sheet1!B44&Sheet1!B45
=Sheet1!B46&Sheet1!B47
=Sheet1!B48&Sheet1!B49
=Sheet1!B50&Sheet1!B51
=Sheet1!B52&Sheet1!B53
=Sheet1!B54&Sheet1!B55
=Sheet1!B56&Sheet1!B57