将格内多行文字展开成多格

表格的A列是分类，B列由多行文字组成，即分隔符是换行符。

	A	B
1	Account Number	Interaction
2	1	Jan 1,2023 - Hello.
3	2	Jan 2, 2023 - Good morning. Jan 3, 2023 - Good night. Jan 4, 20 Jan 5, 2023 - Good night. Jan 6, 2023 - Good afternoon.
4	3	Jan 1,2023 - Good night. Jan 2, 2023 - Good afternoon.

请将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 在多层循环中按层数返回循环变量。