问如何连接excel中的单元格(行向)，直到找到值为止？

EN

Row     Column A
1   AAA Number of ABC
2   Streaming Call
3   Explanation
4   BBB Number of ABC
5   Streaming Call
6   from source
7   Explanation
8   CCC Number of ABC
9   Streaming Call
10  from source
11  to Dest
12  Explanation
...
...
196000  Explanation

1   AAA Number of ABC   AAA Number of ABC
2   Streaming Call          AAA Number of ABC Streaming Call
3   Explanation         Explanation
4   BBB Number of ABC   BBB Number of ABC
5   Streaming Call          BBB Number of ABC Streaming Call
6   from source         BBB Number of ABC Streaming Call from source
7   Explanation         Explanation
8   CCC Number of ABC   CCC Number of ABC
9   Streaming Call          CCC Number of ABC Streaming Call
10  from source         CCC Number of ABC Streaming Call from source
11  to Dest                 CCC Number of ABC Streaming Call from source to Dest
12  Explanation         Explanation
...
....