将格内多行文字展开成多格
表格的A列是分类，B列由多行文字组成，即分隔符是换行符。
A |
B |
|
1 |
Account Number |
Interaction |
2 |
1 |
Jan 1,2023 - Hello. |
3 |
2 |
Jan 2, 2023 - Good morning. |
4 |
3 |
Jan 1,2023 - Good night. |
请将B列的每格展开成多个单元格，并复制A列
A |
B |
|
1 |
Account Number |
Interaction |
2 |
1 |
Jan 1,2023 - Hello. |
3 |
2 |
Jan 2, 2023 - Good morning. |
4 |
2 |
Jan 3, 2023 - Good night. |
5 |
2 |
Jan 4, 20 |
6 |
2 |
Jan 5, 2023 - Good night. |
7 |
2 |
Jan 6, 2023 - Good afternoon. |
8 |
3 |
Jan 1,2023 - Good night. |
9 |
3 |
Jan 2, 2023 - Good afternoon. |
使用 SPL XLL
=spl("=?.news@q(~2.import@si();[get(1)(1),~])",A2:B4)
函数 news@q 用序列的成员生成新序列，~2 是当前变量的第 2 个成员,import@si将字符串按回车解析成单行字符串组成的序列，get 在多层循环中按层数返回循环变量。
https://www.reddit.com/r/excel/comments/1crmocu/how_do_i_separate_a_cell_into_different_rows/
英文